SQL WHERE Syntax
WHERE Clause Example
SQL uses single quotes around text values; some versions will allow double quotes. Numeric values should not be enclosed in quotes. Operators Allowed in the WHERE Clause are as follows:
= – Equal<> – Not equal!= – Not equal> – Greater than< – Less than>= – Greater than or equal<= – Less than or equalBETWEEN = – Between an inclusive rangeLIKE = – Search for a patternIN = – If you know the exact value you want to return for at least one of the columns
