[SOLVED] Using REGEXP in MYSQL queries

[ac1982]

hi

 

I have a table with the name projects and the field status is a string and an example of what the field contains is: status = '12,10,9,99,1'. I would like to create a select statement that will return all fields that inside the status field there is the value 9 and not 99. I tried the following but no results.

 

SELECT *

FROM `projects`

WHERE status REGEXP '(.*)(9)(.*)'

[fenway]

Your real problem is that you're storing a list.  Change your DB structure... but for now, use FIND_IN_SET, not a REGEXP.

[ac1982]

Thank you for your help I didn't know that a function like exists.