Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

25021 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

SQL: Where Clause

sql SQL: Where Clause SQL: Asking questions of your data

Following on from our previous video of how to display results from SQL by use of the select statement. We are now going to discuss the basics of filtering our information by use of the “where” clause.

The SQL Where Clause

Asking questions of your data is one of the most common things you will want to do.

The where clause can become a large area of complex criteria where the human way of asking for information will become a little off compared to how you would ask a computer.  For example, if I wanted to look for two citys say,”London” and “Paris” you would probably say your where clause would be this:

Where City = ‘London’ or ‘Paris’

This however is incorrect as you would need to define the feild twice.  So the correct response would be:

Where City = ‘London’ or City = ‘Paris’

There are more than one way to interogate too!  Another option would have been to use the “in” function so in this case it would read:

Where City in(‘London’,’Paris’)

Okay, starting to get more complex now?  This is one of those learning curves that if you want to master database you need to fully understand.

After watching this video you should have a rudementary understanding of how you would filter your results.  This is by no means the end of how you would interrogate the data but discusses the fundamentals required to progress onto the more complex avenues of SQL.

Other SQL Videos

This video is one of many SQL tutorials on this site click here for more

Related Posts

85 Comments

  1. cal wu says
    25 Feb 15 at 7:05pm

    the accent is sexy

  2. THFC7788 says
    24 Nov 13 at 4:40am

    Good Stuff

  3. Sinan Basalan says
    06 Apr 13 at 9:32pm

    Its brilliant

  4. MrCavitysChessCorner says
    18 Mar 13 at 4:41pm

    Why are the British so good at making tutorials? Seriously, you guys are crazy good at it.

  5. povar1981 says
    03 May 12 at 8:56am

    Great tutorial, you covered lots of basics in such a short time! But it’s sometimes hard to read the text of the statements because the font is too small. Can you please show the textual version of the commands used?

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security