'Get exact value with letter case

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?

mysql sql

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source