Re: Select * From table where name Like 'help'; Help

[Robert Citek]

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