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