Is there a way to restructure your table? I don't know what the data represents, but you could use a field per list item( you could then index it t get very fast results).
You could also use 'like' to grab a larger then needed set, then use PHP to filter the data (also inefficient).
-Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
