应用开发笔记

Home Archives
2011-11-20
PHP开发

Mysql查询不区别大小写方法

使用upper或lower函数,如,查询表table1,条件是actor字段模糊查询 select * from table1 where upper(actor) like '%AAA%'; 当然,我们得先在程序中把like的值也全部转为大写

Share
Newer
Eclipse 未能打开编辑器:未能实例化编辑器类错误解决方法
Older
Java ArrayList动态数组排序

Archives

  • September 2019
  • August 2019
  • June 2019
  • January 2019
  • October 2018
  • August 2018
  • July 2018
  • June 2018
  • January 2018
  • December 2017
  • September 2017
  • August 2017
  • May 2017
  • April 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • August 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • October 2015
  • August 2015
  • June 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010

Recent Posts

  • 国内环境kubernetes安装配置
  • 博客迁移到Hexo
  • Spring cloud使用zookeeper作为分布式配置中心
  • Kong http 301跳转到https插件
  • kong admin ui Custom Headers使用说明 给你的kong加个密码
© 2019 pocketdigi
Powered by Hexo
Home Archives