mysql 查询小写_mysql查询时区分大小写

最新推荐文章于 2023-04-12 11:24:20 发布

林文曦

最新推荐文章于 2023-04-12 11:24:20 发布

阅读量50

点赞数

文章标签： mysql 查询小写

本文链接：https://blog.csdn.net/weixin_42114645/article/details/113140232

版权

博客内容介绍了在MySQL数据库中进行查询时如何处理大小写问题。通过示例插入了多个河南省的城市数据，并讨论了在查询过程中如何确保不区分大小写进行匹配的方法。

摘要由CSDN通过智能技术生成

在表中增加一些数据：

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('1','河南','安阳','2019-03-14 09:57:29','ay');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('2','河南','郑州','2019-03-14 10:10:02','zz');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('3','河南','洛阳','2019-03-14 10:10:56','ly');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('4','河南','漯河','2019-03-05 10:14:27','');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('5','河南','新乡','2019-03-05 10:14:27','');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('6','河南','濮阳','2019-03-05 10:14:27','');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('7','河南','焦作','2019-03-05 10:14:27','');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('8','河南','鹤壁','2019-03-05 10:14:27','');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('9','河南','开封','2019-03-05 10:14:27','');

关注