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