Get exact value with letter case

Question

I executed this query:

SELECT name FROM `product` WHERE `name` like "product%"

It returns "product 01" and "Product 02". Check here second value has capital "P" which is unwanted in result.

So how can I solve this?

Possible duplicate of [How can I make SQL case sensitive string comparison on MySQL?](http://stackoverflow.com/questions/5629111/how-can-i-make-sql-case-sensitive-string-comparison-on-mysql) — TMichel, Nov 24 '15 at 11:57

score 1 · Accepted Answer · edited Mar 04 '22 at 21:26

1

You can try BINARY

SELECT name FROM `product` WHERE BINARY `name`  like 'product%'

edited Mar 04 '22 at 21:26

Dharman

answered Nov 24 '15 at 12:01

Subin Chalil

1 Answers1