Changes

Advanced MySQL Data Filtering - AND, OR, NOT and IN

477 bytes added, 18:40, 12 October 2007
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.

== Filtering using the OR Operator ==