WHERE doesn't have an option for case insensitive, lower or uppercase

catfan / Medoo

The lightweight PHP database framework to accelerate the development.

https://medoo.in

MIT License

4.83k stars 1.15k forks source link

WHERE doesn't have an option for case insensitive, lower or uppercase #225

Closed AdrianVerde closed 9 years ago

AdrianVerde commented 9 years ago

An option that can get the same results as a query like SELECT mail FROM users WHERE LOWER(mail) = 'user@domain.tld'; through $medoo->has, get or select would be great :D

catfan commented 9 years ago

The better way is using PHP native function to do that.

AdrianVerde commented 9 years ago

Yeah, and/or using case insensitive collation in the database, already did, thanks.