please correct my mysql query

[piyush23424]

I have comma separated values in table column name cityid(datatype is varchar).

 

Now i want to fetch the records  from that table based upon those ids with pattern matching technique

 

eg. cityid has 3,4,5,10,5,60,2  values.

 

Here each id is reference to different cities.

 

i have tried following query but it didn't worked for me

 

$sql = "Select * from table where cityid like %id%"

 

i think we can do it with pattern matching. please help

 

Thanks

 

 

 

[suresh_kamrushi]

Hi,

you can do it with the help of regular expression in Mysql

 

Select * from table where cityid REGEXP '^9,|,9$|,9,' OR cityid =9

[Maq]

CSV fields are a horrible idea, don't do that.  You need to use the IN() function.

[suresh_kamrushi]

IN() will not work for CSV!!!!!!!!!!!!

[The Little Guy]

IN() will not work for CSV!!!!!!!!!!!!

 

I think he means convert the csv to single rows, then do an in on it.