How to understand that the right white space character appears in the WHERE of MariaDB and MySQL

How to understand that the right white space character will appear in the WHERE of MariaDB and MySQL. In view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

Version 10.4.8-MariaDB-1:10.4.8+maria~bionicMySQL 8.0

In the select xxx from xxx where field = 'yyy' statement, if there is a space at the end of the yyy or there is a space at the end of the field, the space at the end of the line is removed during the comparison and the comparison is made. The space at the beginning of the line will not be removed, the field will not be indexed, and like 'yyy' will match exactly. I don't know if it's a feature or BUG.

This is the answer to the question about how to understand the right white space character in the WHERE of MariaDB and MySQL. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.