> 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...?

You can use "AND aColumn LIKE '%%'"


---------------------------------------------------------------------
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

Reply via email to