deezy Posted May 29, 2008 Share Posted May 29, 2008 Hi. There are values in my database stored like so: +----------+ | num | +----------+ |2,4,8,9,11 | A dropdown on my webpage contains a list of numbers. Is it possible to query the database to return all rows that contain one of the numbers in the 'num' field even though they are separated by commas? Thanks Link to comment https://forums.phpfreaks.com/topic/107769-query-comma-seperated-field/ Share on other sites More sharing options...
deezy Posted May 29, 2008 Author Share Posted May 29, 2008 Just bumping this as i have still not been able to find a solution, thanks Link to comment https://forums.phpfreaks.com/topic/107769-query-comma-seperated-field/#findComment-553013 Share on other sites More sharing options...
fenway Posted May 30, 2008 Share Posted May 30, 2008 Yes... use FIND_IN_SET(). Link to comment https://forums.phpfreaks.com/topic/107769-query-comma-seperated-field/#findComment-553709 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.