List of Values in Column

[Chan]

I will have a list of values in a column on my table. I need to write a SQL query that detects if the value is in the column. An example of the data would be:

8,9,20,44,39,82

and say the value was 44. Is there a regex express I could use in PHP/SQL to determine if the value is actually present?

[John]

Can't you just do something like this?

PHP Code:

//if the query is successful, the value is present...
if(mysql_query('SELECT column FROM table WHERE column=44'))
$value = true; 


[Jordan]

If you are asking how to determine if the value '44' is in a field that contains all of those values you could easily use regexp.

SELECT * from table
WHERE field REGEXP '44,'
;

More Info: MySQL AB :: MySQL 5.0 Reference Manual :: 12.4.2 Regular Expressions

[Chan]

The regexp works but I had to add a comma before and after:

,10,89,13,47,

because with your REGEXP it never found the last ID (no ending comma) and it would find numbers that ended with '44'

[John]

Of course the REGEXP works, Jordan is a genius.

[Jordan]

Originally Posted by Chan

The regexp works but I had to add a comma before and after:

,10,89,13,47,

because with your REGEXP it never found the last ID (no ending comma) and it would find numbers that ended with '44'

Yeah, I didn't think about that but if adding a starting and ending comma is no problem I think this method is solid.

Originally Posted by Sidewinder

Of course the REGEXP works, Jordan is a genius.

Well thank you!

[iqstaffing]

You could have also used MYSQL 'LIKE' function

SELECT * from table
WHERE field LIKE '%,47,%' 
;