Sql comparison operators

AND/OR

SELECT * FROM users
WHERE name = 'foo' OR name = 'bar'

IN

SELECT * FROM users WHERE name IN ('john', 'jane', 'iggy');
SELECT * FROM users WHERE name NOT IN ('john', 'jane', 'iggy');

BETWEEN

SELECT * FROM users WHERE age BETWEEN  30 AND 40;

REGEXP

'.'             # any single character
'[A-z][0-9]'    # character range
'[0-9]*a'       # Matches any or no occurrences of [0-9].
'^a'            # matches lines starting with 'a'
'a$'            # matches lines ending with 'a'
'^aaa$'         # matches 'aaa'. not '*aaa*' (which is default in mySQL)
'aaa'           # matches '.*aaa.*' unless anchored with '^' or '$'

Example.

SELECT * FROM users WHERE name REGEXP '^Andr'

LIKE

glob-style matching (% represents any or no characters).

SELECT * FROM users WHERE name LIKE 'Andr%';