错误记录:FUNCTION mytest.CONCATE does not exist
如下:
SELECT city_id ,city_name,airport_name,city_code,city_pinyin,city_abbreviation FROM city_airport WHERE 1=1
AND city_name LIKE CONCAT('%',"上海",'%') AND city_code LIKE CONCATE('%',"SH",'%')