TalkPHP - View Single Post - Comparing string from array with mysql field

sketchMedia · 11-29-2010, 10:30 AM

Would the IN() function of MySQL be a better approach to the problem.

sql Code:

SELECT * FROM `table` WHERE `field` IN(1, 4, 27, 34, 55)

11-29-2010, 10:30 AM	#3 (permalink)
sketchMedia The Prestige Join Date: Oct 2007 Location: Manchester, UK Posts: 854 Thanks: 32	Would the IN() function of MySQL be a better approach to the problem. sql Code: SELECT * FROM `table` WHERE `field` IN(1, 4, 27, 34, 55) __________________ mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0; Empty set (0.00 sec)