you may use this query it may help

 select * from mytable
where CONCAT(field1,field2,field3,...) like '%string%'