Paul Novitski wrote:
At 4/26/2007 11:33 PM, Sebe wrote:i have a mysql column that looks like this:groups ------- 12,7,10,6,14,11,2 is it possible to select the row if `groups` contain 7 or 14? trying to avoid running two queries and running explode() on it.I would think a more efficient strategy would be a simple string search. If you append a comma to the beginning and the end of your list so it becomes:,12,7,10,6,14,11,2, then you can search for: ,#, where # is the desired integer. Therefore you could use the MySQL syntax: WHERE CONCAT(',', `groups`, ',') LIKE '%,7,%' OR CONCAT(',', `groups`, ',') LIKE '%,14,%' Regards, Paul
thanks for the idea.. i also just came up with a solution using mysql FIND_IN_SET
eg: FIND_IN_SET('7', groups) OR FIND_IN_SET('14', groups)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
