[ SOLVED ] SQL Like Handling (Active Record class)

[eluser]plain jane[/eluser]

Code:

WHERE (`publish` != ‘no’)AND (`title`  LIKE ‘%keyword%’ OR `brand`  LIKE ‘%keyword%’ OR `property`  LIKE '%keyword%’ OR `group`  LIKE ‘%keyword%’ OR `format`  LIKE ‘%keyword%’ OR `isbn`  LIKE ‘%keyword%’)

This is what we want

Code:

publish !='no' AND (title, brand, property, group, format, isbn LIKE keyword)

Correct me if i am wrong.