Select case insensitive using php and pdo

Asked Feb 02 '17 at 16:19

Active Feb 02 '17 at 16:19

Viewed 487 times

How to make this sql statement case insensitive as to accept $_POST["CatType"]] to be wet-beans or Wet-beans or WET-BEANS?

$stmt ="SELECT distinct Product_Name FROM Products WHERE Product_Name='".$_POST["CatType"]."'And Category_ID=(SELECT Category_ID from Categories WHERE Category_Name='".$_POST["CatName"]."')";

asked Feb 02 '17 at 16:19

New at Leaflet

One way is to wrap both sides with `lower` or `upper` but be mindful that it will result in indexes on those column being useless to your query if any. – Gurwinder Singh Feb 02 '17 at 16:20
Which rdms are you using? – Stephan Lechner Feb 02 '17 at 16:22
Similar question already [answered here](https://stackoverflow.com/questions/3936967/mysql-case-insensitive-select) – Arsalan Mithani Feb 02 '17 at 16:22
Well, I should have clarified, is this MySQL? – AbraCadaver Feb 02 '17 at 16:24
I am using phpmyadmin, and i tried `lower` or `upper` but doesn't work – New at Leaflet Feb 02 '17 at 16:31

Select case insensitive using php and pdo

0 Answers0