thanks for those who helped about my OR query in the join, if the sql containes "IN (something)" it is much faster. but i have a similar question relating to regexp. sorry i am not too good with regexp so wouldapprecite some help.
my sql is like this: where col1 like '%abc%' or col1 like '%cdf%' or col1 like '%fgh%' how can i break this into a regexp query, so that i can remove the OR condition altogether and instead rely on regexp? can i do that? like this: where REGEXP(col1, "^[abc|cdf|fgh]$") or something like that? thanks/erick __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
