Are MySQL SELECT Statements Case Sensitive? - MySQL FAQ
MySQL SELECT statements are not case sensitive. This means that you can write your SELECT queries using upper or lowercase letters, or a combination of both, without affecting the results. However, it is important to note that this applies only to the SELECT statement itself, not to the data being queried.
For example, if you have a table with the following data:
| ID | Name | Age |
| 1 | John | 25 |
| 2 | john | 30 |
| 3 | JANE | 35 |
And you execute the following query:
SELECT * FROM table WHERE name = 'john'
You will get two results, for ID 1 and 2, because the query is not case sensitive. However, if you execute the following query:
SELECT * FROM table WHERE name = 'JANE'
You will get only one result, for ID 3, because the query is case sensitive and matches only the uppercase name 'JANE'.
In conclusion, MySQL SELECT statements are not case sensitive, but it is important to be aware of the case sensitivity of the data being queried in order to retrieve accurate results.