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
