Advanced MySQL Data Filtering - AND, OR, NOT and IN
From Techotopia
Revision as of 18:40, 12 October 2007 by Neil (Talk | contribs) (New page: In the previous chapter of MySQL Essentials we looked at some basic filtering of retrieved data using the ''WHERE'' clause of the ''SELECT'' statement. While the basics covered simple ...)
In the previous chapter of MySQL Essentials we looked at some basic filtering of retrieved data using the WHERE clause of the SELECT statement. While the basics covered simple filtering techniques, there are often situations where more sophisticated filtering is required. To address this need, the WHERE clause allows multiple conditions to be defined in a single SELECT statement using AND, OR and NOT operators.
