Hello!
David Durham wrote:
> If this question is off topic, please let me know.
>
> I have a description field with a set of keywords. I need to update
> some data based on a keyword, which is randomly placed in the field.
> Can someone please help with a SQL syntax to find the word within the
> field.
WHERE field LIKE '%keyword%'
maybe
WHERE upper(field) LIKE upper('%keyword%')
Greetings
Ralf
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de
---------------------------------------------------------------------
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
