RE: is there a MySQL 'field contains' function

2002-04-12 Thread Roger Baklund
* Bill > Hello Everyone, > I've only just started trying to use MySQL so please forgive my > ignorance if this sounds like a really basic question! > I am trying to search a text field within a table that contains > several keywords; for example the column might be called > "computer_d

Re: is there a MySQL 'field contains' function

2002-04-12 Thread BD
At 10:09 AM 4/12/2002, you wrote: >Hello Everyone, > I've only just started trying to use MySQL so please forgive my > ignorance if this sounds like a really basic question! > I am trying to search a text field within a table that contains > several keywords; for example the colu

RE: is there a MySQL 'field contains' function

2002-04-12 Thread Gregory Junker
SELECT * FROM table1 WHERE computer_description LIKE '%blue%' HTH Greg > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 12, 2002 11:10 AM > To: [EMAIL PROTECTED] > Subject: is there a MySQL 'field contains&#x

Re: is there a MySQL 'field contains' function

2002-04-12 Thread John Klein
[EMAIL PROTECTED] wrote: > > I am trying to search a text field within a table that contains > several keywords; for example the column might be called > "computer_description" and contain the values "i-mac blue 256MB > 500MHz ...". Is there any way of putting together a query that says >

RE: is there a MySQL 'field contains' function

2002-04-12 Thread Svensson, B.A.T. (HKG)
> Hello Everyone, > I've only just started trying to use MySQL so please forgive my > ignorance if this sounds like a really basic question! > I am trying to search a text field within a table that contains > several keywords; for example the column might be called > "computer_descr

is there a MySQL 'field contains' function

2002-04-12 Thread bill
Hello Everyone, I've only just started trying to use MySQL so please forgive my ignorance if this sounds like a really basic question! I am trying to search a text field within a table that contains several keywords; for example the column might be called "computer_description"