Re: Compare a given value with multiple values field
| From: | Kae Verens | Date: | Mon, 18 Sep 2006 14:44:29 +0000 |
| Subject: | Re: Compare a given value with multiple values field | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42365@lists.php.net to get a copy of this message | ||
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