How to query case sensitivity in mysql

In mysql, you can use the binary keyword to query case-sensitive. The function of this keyword is to make case-sensitive in the query statement. The syntax is "select * from table name where binary field name like 'query field ';".

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

How does mysql query case sensitivity

MySQL query is not case-sensitive by default. If you need to be case-sensitive, you must query An example of adding binary

before the condition is as follows:

##Recommended learning:

mysql video tutorial

The above is the detailed content of How to query case sensitivity in mysql. For more information, please follow other related articles on the PHP Chinese website!