The escape character in the SQL statement like clause [reproduced]

If you want to query in SQL like with an underscore ' _ ' or a '% ' equivalent of a record, write directly to like ' xxx_xx ', then ' _ ' will be treated as a wildcard character like. The escape clause is provided in SQL to handle this situation, and escape can specify what escape character is used in like, and the character after the escape character will be treated as the original character, which is much like the ' \ ' in C, but escape requires the custom escape character instead of the ' \ ' characters. Such as:

SELECT * FROM user_all_tables where table_name like ' yw__% ' escape ' _ '
The meaning is to identify all tables under the current user table that begin with ' Yw_ ', where the first ' _ ' is the escape character and the second is the escaped characters, the equivalent can be written as:
SELECT * FROM user_all_tables where table_name like ' yw\_% ' escape ' \ '

The escape character in the SQL statement like clause [reproduced]