You can search for wildcard characters by using the escape character and searching for them as literals. There are two ways to use the wildcard characters as literals in a like match string: square brackets and the escape clause.
The match string can also be a variable or a value in a table that contains a wildcard character.
Use square brackets for the percent sign, the underscore, and right and left brackets. To search for a dash, rather than using it to specify a range, use the dash as the first character inside a set of brackets.
Use the escape clause to specify an escape character in the like clause. An escape character must be a single-character string. Any character in the server’s default character set can be used.