SELECT *
FROM `tak_lo`.`jos_menu`
WHERE `id` LIKE '%site.mynet.com%'
OR `menutype` LIKE CONVERT( _utf8 '%site.mynet.com%'
USING latin2 )
COLLATE latin2_general_ci
OR `name` LIKE CONVERT( _utf8 '%site.mynet.com%'
USING latin2 )
COLLATE latin2_general_ci
OR `link` LIKE CONVERT( _utf8 '%site.mynet.com%'
USING latin2 )
COLLATE latin2_general_ci
OR `type` LIKE CONVERT( _utf8 '%site.mynet.com%'
USING latin2 )
COLLATE latin2_general_ci
OR `published` LIKE '%site.mynet.com%'
OR `parent` LIKE '%site.mynet.com%'
OR `componentid` LIKE '%site.mynet.com%'
OR `sublevel` LIKE '%site.mynet.com%'
OR `ordering` LIKE '%site.mynet.com%'
OR `checked_out` LIKE '%site.mynet.com%'
OR `checked_out_time` LIKE '%site.mynet.com%'
OR `pollid` LIKE '%site.mynet.com%'
OR `browserNav` LIKE '%site.mynet.com%'
OR `access` LIKE '%site.mynet.com%'
OR `utaccess` LIKE '%site.mynet.com%'
OR `params` LIKE CONVERT( _utf8 '%site.mynet.com%'
USING latin2 )
COLLATE latin2_general_ci
LIMIT 0 , 30