Re: SQL Syntax (May be OT)

2002-07-25 Thread Ralf Narozny 

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

RE: SQL Syntax (May be OT)

2002-07-25 Thread Barnali 

Use LIKE '%KEYWORD%'

At least this works for Oracle

-Original Message-
From: David Durham [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 3:39 PM
To: [EMAIL PROTECTED]
Subject: SQL Syntax (May be OT)


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.

Thanks in anticipation.

-David


-
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


-
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