How would you make a case-insensitive query in MySQL?
SELECT * FROM customers WHERE UPPEERCASE(LastName) = 'POTTER';
SELECT * FROM customers WHERE UPPER(LastName) = 'Potter';
SELECT * FROM customers WHERE LOWERCASE(LastName) = 'potter';
SELECT * FROM customers WHERE UPPER(LastName) = 'POTTER';