select count(a.index_no) as cnt from shop_goods_search as a where and ( concat(a.gname,' ',a.explan,' ',a.gcode) like '%가습기%' or find_in_set('가습기', a.keywords) >= 1 )

1064 : 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 'and ( concat(a.gname,' ',a.explan,' ',a.gcode) like '%가습기%' or find_in_set' at line 2

error file : /m/shop/search.php