mysql查询数据库记录

多列表排序：SELECT  * FROM behavior_record_sync ORDER BY 6 DESC,2

匹配单个字符集：SELECT  * FROM behavior_record_sync where owner_action like '_n'    _匹配单个

组合查询：SELECT  code,warrant as c FROM behavior_record_sync WHERE code like "XN%" UNION SELECT code, warrant from behavior_record_sync WHERE code like "11%"