All pastes #501868 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-05-22 07:50 UTC
rendered paste body
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>