Optimus Pete » 2007 » March

Home | Peteamania | Optimus Pete

Search

Calendar

March 2007
M	T	W	T	F	S	S
« Feb		Apr »
	1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31

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

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 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, database, regular expressions, sql | 1 Comment »

PHP: Remove Values from Array

March 22nd, 2007 by

Pete

If you need to remove elements from an array that have a particular value(s) here’s a neat way of doing it without any looping:

PLAIN TEXT

PHP:

// our initial array
$arr = Array("blue", "green", "red", "yellow", "green", "orange", "yellow", "indigo", "red");
print_r($arr);
// remove the elements who's values are yellow or red
$arr = array_diff($arr, array("yellow", "red"));
print_r($arr);
// optionally you could reindex the array
$arr = array_values($arr);
print_r($arr);

This is the output from the code above:
Array ( [0] => blue [1] => green [2] => red [3] => yellow [4] => green [5] => orange [6] => yellow [7] => indigo [8] => red )
Array ( [0] => blue [1] => green [4] => green [5] => orange [7] => indigo )
Array ( [0] => blue [1] => green [2] => green [3] => orange [4] => indigo )

Pete Graham xXx

Posted in Tech, arrays, php, programming | 13 Comments »

Search

Pages

Calendar

Categories

SQL: Selecting Specifying Multiple Field Values

PHP: Remove Values from Array