Mysql中模糊查询区分大小写的两种方法 2022-09-03 10:16:51 在oracle中模糊查询默认区分大小写,在mysql中默认不区分一、查询语句上加binaryselect * from user where user.name like binary '%T956' order by id二、建表时加binarycreate table t{ code varchar(10) binary }