mysql>  SELECT COUNT( * ) AS count
    -> FROM `usr_web29_1`.`__best_hotel_room`
    -> WHERE `id` LIKE CONVERT( _utf8 '%test%'
    -> USING )
    -> COLLATE OR `lid` LIKE '%test%'
    -> OR `name` LIKE '%test%'
    -> OR `price_min` LIKE CONVERT( _utf8 '%test%'
    -> USING )
    -> COLLATE OR `price_max` LIKE CONVERT( _utf8 '%test%'
    -> USING )
    -> COLLATE OR `mcid` LIKE CONVERT( _utf8 '%test%'
    -> USING )
    -> COLLATE OR `sort_order` LIKE CONVERT( _utf8 '%test%'
    -> USING )
    -> COLLATE
    ->
    -> ;