The default query of mysql is not case-sensitive; if you need to be case-sensitive, you can use the Binary keyword to set the query statement to be case-sensitive when querying. The syntax is "select * from table name WHERE binary field = field value".
The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.
MySql default query is not case-sensitive. If you need to distinguish it, you must mark sensitive attributes in Binary when creating the table.
Examples are as follows:
CREATE TABLE NAME(name VARCHAR(10));
For this table, by default, the results of the following two queries are the same:
SELECT * FROM TABLE NAME WHERE name='clip'; SELECT * FROM TABLE NAME WHERE name='Clip';
Add binary
select * from users WHERE binary user_name = '张三' AND status != 0
to the query statementExtended knowledge:
MySQL is not case-sensitive under Windows. After importing the script file into MySQL, the table name will be automatically converted to lowercase. As a result, you want to export the database to An error occurred when using it in a linux server.
Because the table name is case-sensitive under Linux, the table cannot be found. I checked a lot and said that I can change the settings of MySQL under Linux so that it is not case-sensitive. But is there a way to make it case-sensitive in Windows? It's case sensitive.
In fact, the method is the same, just change the MySQL settings in windows accordingly.
Specific operation:
Add a line in the MySQL configuration file my.ini:
lower_case_table_names = 0
Among them, 0: case-sensitive, 1: case-insensitive
MySQL's case rules for database names, table names, column names, and aliases under Linux are as follows:
1. Database names and table names are strictly case-sensitive;
2. Table aliases are strictly case-sensitive;
3. Column names and column aliases are case-insensitive in all cases;
4. Variable names are also strictly case-sensitive. Case-sensitive; MySQL is not case-sensitive under Windows
Recommended learning:mysql video tutorial
The above is the detailed content of Is mysql query case sensitive?. For more information, please follow other related articles on the PHP Chinese website!