Hassan wrote:
I guess this is this closest, but apparently in this case if the "3" at the 
beginning doesn't exact, and even using LIKE '%3,%' (removing the first comma) would 
match an entry like 33, !
I need a better solution, does mysql have something similar to explode() in PHP?
  if it does, then how to apply it in my situation?
  of course it done using PHP but that's not feasible at all.


why would you have multiple values held within one field? Why can't you have a separate entry for each value?

see http://en.wikipedia.org/wiki/Database_normalization

Kae

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to