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
    ->
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
COLLATE OR `lid` LIKE '%test%'
OR `name` LIKE '%test%'
OR `price_min` LIKE CON' at line 4
mysql>