Use Trim () in MySQL to remove characters from both sides

In some cases, the value of some fields in the data table will appear with a white-space character if the program is not handled properly, as

This will not match if it is strictly compared to name. The trim () function solves this problem

As a subset of the trim () function, the LTrim () function is the special character that handles the left side of the character, and RTrim () handles special characters to the right of the character

Use Trim () in MySQL to remove characters from both sides