How to fetch the Exact UPPERCASE values from a column in MySQL?
How to fetch the Exact UPPERCASE values from a column in MySQL? If a column have uppercase value like "NEW". We want to take the exact value from the table. SELECT * FROM sales WHERE status REGEXP BINARY '^[A-Z]{2,}' AND uploadeddate LIKE '%2017-03-31%' AND status = 'NEW';