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' function > > > 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" and contain the values "i-mac blue 256MB > 500MHz ...". Is there any way of putting together a query that says > something like: > SELECT * from table1 WHERE computer_description CONTAINS 'blue' ? > or should I separate this column up into several others > type, colour, > ram, processor etc...? > > Thanks, > > Bill > > > > --------------------------------------------------------------------- > 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
