MySQL模糊查询

select * from test_table where INSTR(brand,'保时捷')


select * from test_table where brand like '%保时捷%'


select * from test_table where LOCATE('保时捷',brand) > 0

MySQL缺省 排序问题，多排序条件的值一致，缺省排序