Searching entire MySql table for keyword

[michaelvleugel]

Hi,

I wonder if anyone can tell me if the following MySql query makes any sense at all, or if there\'s better ways of doing this: I want to look for two user-defined words in an entire table.

SELECT * FROM table WHERE ((CONCAT(row1,row2,row3,row4) LIKE \'%searchword1%\') =1 AND (CONCAT(row1,row2,row3,row4) LIKE \'%searchword2%\')=1 ;

I\'m wondering if this query isn\'t overdone in any way?

Thanks!

Mike

[michaelvleugel]

Oops - forgot some parenthesis -

SELECT * FROM table WHERE ((CONCAT(row1,row2,row3,row4) LIKE \'%searchword1%\') =1) AND (CONCAT(row1,row2,row3,row4) LIKE \'%searchword2%\')=1)

[Anon]

I wonder is this a valid SQl statement ???