SQL: Selecting Specifying Multiple Field Values
March 22nd, 2007 by 
Pete
Here are 3 different ways to perform a DB select when you want to specify two or more values for a field.
1. Use th OR operator
SQL:
-
SELECT * FROM people
-
WHERE (first_name = 'pete'
-
OR first_name = 'paul');
2. Use a Regular Expression
SQL:
-
SELECT * FROM people
-
WHERE first_name ~'^pete|paul$';
3. Use an array
SQL:
-
SELECT * FROM people
-
WHERE first_name = ANY('{pete,paul}');
Note: These should all work in PostgreSQL, I suspect the SQL may need altering for 2 and 3 to work with MySQL.
# Pete Graham
Posted in Tech, regular expressions, database, sql | 
No Comments »