Detailed explanation of the problem of matching even when there is a space at the end of the string in the Mysql query condition

1. Table structure

TABLE person

2. Query and Results

select * from person where `name` = ?

regardless? = "you + a few spaces", all three results will be retrieved.

3. Reasons

MySQL's collation rules are PADSPACE, which ignores trailing spaces.

It is aimed at text data types such as varchar char text...

This is SQL standardized behavior. No settings are required and cannot be changed.

4. What if you want to make an accurate query?

Method 1: like

select * from person where `name` like ?

Method 2: BINARY

select * from person where `name` = BINARY ?

BINARY is not a function, but a type conversion operator. It is used to force the string behind it to be a binary string, which can be understood as an exact match.

The above are all the relevant knowledge points introduced this time. If you have any additions, please contact the editor of 123WORDPRESS.COM.