At 21:57 -0700 7/30/02, Erick Papadakis wrote: >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]$")
You don't want ^ or $ if you want to find the the strings anywhere in the column value. Also, REGEXP is an operator, not a function. WHERE col1 REGEXP "abc|cdf|fgh" > >or something like that? > >thanks/erick --------------------------------------------------------------------- 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
