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 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
Bill,
See the MySQL manual on pattern matching.
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Pattern_matching
Since you are just starting out, I'd recommend reading as much of
the manual as possible. It is interesting and well written. You can
download it as a PDF if you like. Also get your hands on the book called
"MySQL" by Paul Dubois. It makes learning MySQL fun. :)
Brent
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
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
