I've got a comma delimited list that I'd like to match against a single value in a mySQL table:
e.g.:
$commaList="1,2,4"
and I select all rows which have a particular column with a value contained in that list.
is there some mysql function that allows for substring matching? LIKE isn't working, though I could be using it incorrectly...
thanks much
adam altman
e.g.:
$commaList="1,2,4"
and I select all rows which have a particular column with a value contained in that list.
is there some mysql function that allows for substring matching? LIKE isn't working, though I could be using it incorrectly...
thanks much
adam altman