Try the REGEXP modifier. For example: mysql> select "Another One" regexp "[[:<:]]One[[:>:]]" ; mysql> select "Fashioned" regexp "[[:<:]]One[[:>:]]" ;
The format differs from that used in sed, grep, awk, perl, python, etc. http://www.mysql.com/documentation/mysql/bychapter/manual_Regexp.html#Regexp Regards, - Robert ----- At 07:50 PM 12/9/2002 -0500, Beauford.2003 wrote: > If I search for the word - One - I want to see: > Another One > But not: > Fashioned --------------------------------------------------------------------- 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