The SQL statement fuzzy query contains the wildcard "%", and the Placeholder "_" uses escape characters.

For example, a handwritten SQL statement

 

 
  --Query data in the lastname column containing "a_ B"
SelectLastnameFromEmployeesWhereLastnameLike '% A_ B %'
 

 

In the preceding SQL statement, "a_ B" contains "_", which is regarded as a placeholder During query. As a result, "ACB" and "ADB"... are all search results,

This is not the expected result.

Escape characters can be used.

 

 
  --Query data in the lastname column containing "a_ B"
SelectLastnameFromEmployees wher lastnameLike '% A \ _ B %' Escape '\'
 

 

For more information about the use of escape in SQL, see Google.