Friday, 6 September 2013

Search in column that has array(value1,value2,...) in sql table

Search in column that has array(value1,value2,...) in sql table

I have a sql table called "Offres"
inside this table a column named "regions" has array in it (value1,
value2, value3,...)
row1 :"35,2,15,69,98"
row2 :"7,9,15,5,69"
row3 :"7,3,45,5,6"
how can I search rows which has multiple value in same time
for exp : I want to search rows which has 15,69 in it
the result should display row1 and row2
thanks

No comments:

Post a Comment