Try regexp '[[:<:]]your string[[:>:]]'
[[:<:]] and [[:>:]] will anchor your string to where you want.
Mind REGEXP is case sensitive. To ignore case, generate a class string
before you query MySQL.
Good luck
On Sun, 17 Oct 1999, Andreas Gietl wrote:
> hi i'am having a little problem making mysql search for a string that
> does not completly match the searched field, but does just CONTAIN the
> search string.
> Is it possible to realize this withing Mysql or do i have to do this
> within my programm?
>
> thank you
>
> andreas
>
> --
> andreas gietl
> gietl internet services
> fon +49 9402 2551
> fax +49 9402 2604
> mobile +49 171 60 70 008
> gietl@stripped
>
> ############################################
> # Das Handbuch sagt, das Programm benvtige #
> # Windows 95 oder besser. Also habe ich #
> # Linux installiert! #
> ############################################
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread16201@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
>
