Category Archives: sql

SQL: Selecting Specifying Multiple Field Values

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
PLAIN TEXT
SQL:

SELECT * FROM people

WHERE (first_name = 'pete'

OR first_name = 'paul');

2. Use a Regular Expression
PLAIN TEXT
SQL:

SELECT * FROM people

WHERE first_name ~'^pete|paul$';

3. Use an array
PLAIN TEXT
SQL:

SELECT * FROM people

WHERE [...]