> ok so you would have to use : > --select count(distinct itemid) from business where name like 'word1' or > name like 'word2' or name like 'word3'; > no other go. If you're not going to use wildcards, then you can use IN. The whole idea of using LIKE is that you can use _ and % as wildcards when searching. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
