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_' at line 2

error file : /m/shop/search.php