need help with a MySQL query!

[lost&found]

OK so lets say you have a table with 6 columns and you want to query with a pattern match on 4 columns. How do I do this?

I can produce accurate result with 1 column like this:

SELECT * FROM tableName WHERE name LIKE '%pattern%'

That works with one column like 'name' but if I wanted to query other columns like name,title,comment,ect how would I form this SQL statement?

details:

MySQL 5.0.77
Al cols are Latin_general_ci

Ya I am a newbie with this stuff.....

[LoveSandra]

bump 4 you

[Spankys Teens]

[QUOTE=lost&found;17182590]

SELECT * FROM Name WHERE name LIKE '%pattern%'

That works with one column like 'name' but if I wanted to query other columns like name,title,comment,ect how would I form this SQL statement?

Try this:

SELECT Name, FROM table
WHERE CONTAINS((COLUMN NAME 1, COLUMN NAME 2), '%pattern%');

[mikke]

..or

..WHERE CONCAT(name,title,comment) LIKE '%name%'

[Spankys Teens]

Originally Posted by mikke

..or

..WHERE CONCAT(name,title,comment) LIKE '%name%'

I forgot about CONCAT ....it's been a few years since i used SQL

[fatfoo]

Good luck with MySQL.

I would love to believe that you are the sexy woman in your avatar.

Look! You can be multiplied by 2!



What part of Canada are you from?

[lost&found]

BC and I am the girl in my avatar!