Escaping wildcard characters in a MySQL fuzzy query

SQL often uses like to fuzzy query, and fuzzy query will use the percent percent "%", underscore "_" these wildcard characters, where "%" matches any number of characters, "_" matches a single character.

If we want to blur a query with a wildcard character string, such as "60%", "user_name", you need to escape the wildcard. As follows, the% after the slash is no longer a wildcard, and the% before the slash still acts as a wildcard character.

Select percent from score where percent like '%0/% ' escape '/';

Escaping wildcard characters in a MySQL fuzzy query