Changes

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

1 byte added, 16:49, 29 October 2007
no edit summary
</table>
<hr>
 
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'' ''IN'' and ''NOT'' operators.