你如何对MySQL和Postgres写一个不区分大小写的查询? [英] How do you write a case insensitive query for both MySQL and Postgres?
问题描述
我在本地运行MySQL数据库进行开发,但是部署到使用Postgres的Heroku。 Heroku处理几乎一切,但我不区分大小写的Like语句变得区分大小写。我可以使用iLike语句,但我的本地MySQL数据库不能处理这个。
什么是最好的方式写一个不区分大小写的查询,兼容MySQL和Postgres?
code> select * from foo where upper(bar)= upper(?);
如果在调用者中将参数设置为大写,则可以避免第二个函数调用。 / p>
I'm running a MySQL database locally for development, but deploying to Heroku which uses Postgres. Heroku handles almost everything, but my case-insensitive Like statements become case sensitive. I could use iLike statements, but my local MySQL database can't handle that.
What is the best way to write a case insensitive query that is compatible with both MySQL and Postgres? Or do I need to write separate Like and iLike statements depending on the DB my app is talking to?
select * from foo where upper(bar) = upper(?);
If you set the parameter to upper case in the caller, you can avoid the second function call.
这篇关于你如何对MySQL和Postgres写一个不区分大小写的查询?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!