mysql query help

[richie]

Hi,

I have the value below coming from a form,

2:16:4:29

Also, I have values stored in a database in this format,

9:0:21:4:36

Is it possible to issue a mysql query that selects those values that have any COLON DELIMITED value in 2:16:4:29

In other words:

SELECT column FROM mytable WHERE in column exists 2 or 16 or 4 or 29

Thanks.

[scorpioy]

You might want to use SUBSTRING_INDEX(str,delim,count)

and check its usage from http://dev.mysql.com/doc/mysql/en/String_functions.html

[richie]

Thanks. I'm checking it out now.

[richie]

I've been unable to use substr_index in a WHERE clause.

REGEXP worked for my purpose:

SELECT * from mytable WHERE mycolumn REGEXP '(23)'