select where a concat like a string

[nicknickoli]

Hi, I'm not getting results with this query. Is there another easy way to search a group of columns for a string?? Thanks in advance.

SELECT *
FROM
	accounts
LEFT JOIN
	advertisers ON (accounts.id = advertisers.account_id)
LEFT JOIN
	publishers ON (accounts.id = publishers.account_id)
WHERE
  CONCAT_WS(' ', company, address, city, region, country, zipcode, phone, advertisers.account_id, advertisers.account_manager_id, publishers.account_id, publishers.account_manager_id)
  LIKE '%%paper%%'

[FijiSmithy]

You might find a better response on an SQL forum but I don't think you can use a function like that in the WHERE clause can you?

[Weedpacket]

nicknickoli wrote:

Is there another easy way to search a group of columns for a string??

Have you considered "WHERE company like '%%paper%%' OR address like '%%paper%%' OR ...."? And is "%%" really correct or do you mean "%"? And why on earth would you need to check to see if the zipcode account_id, or phone number contains the word "paper"?