Hi guys,

I can't seem to figure this one out at the moment, hope you can help me. I'm trying to query a MySQL server with "where row IN('item1','item2','item3')" but would also like to be able to use pattern matching, "where row LIKE 'item1%'".

This returns an empty result:

select * from table where row IN('item1%','item2%','item3%')

I can't seem to figure out how I can do this. Can I combine LIKE and IN in some way or is this just not possible with MySQL?

Hope you guys have some good answers,
Sincerely,
Trymbill

Use OR to add more criteria to the query

WHERE column IN([csv_list]) OR column LIKE wildcard_criteria OR column LIKE wildcard_criteria

Thanks for the response!

Just to get things straight, I can't do "where row IN('%text%')" with MySQL? I have to split up the array I would've liked to put into the IN function and basically query "where row like '%text1%' or row like '%text2%' or row like '%text3%'" ??

What about storing your items to search for as an array, then foreach() through them. Each time adding your "field LIKE '$item%' or" something like

 foreach($array as $item) {  $where .= "field LIKE '".$item."%' OR";  }

Its up to you how you handle the last OR, this code will produce an OR on the end which needs to be removed, you could substr() after the loop to remove it, or maybe write in a check (id use a ternary statement if doing it this way), and a counter so if the counter indicates you are on your last item in the array (use count to get number of items if needed), you dont add the OR at the end But thats just how id get around the problem, maybe its good maybe its not, but it works lol (im no php guru)