SQL wildcard characters

Wildcard characters include the following:

(1)%: denotes 0 or more characters

(2) _: Represents a single character (A_BC)

(3) []: Represents a single character within the range [a-f] [2-9]

(4) [^]: Represents a single character not in range [^a-f] [^2-9]

Syntax format: Test expression like ' wildcard '

Example: (1) SELECT * FROM table where name like ' sheet% '

(2) SELECT * from Yuesubiao where book_name like ' Javac! % ' escape '! '

（“ ！ ": Used to differentiate between"% "in the characters to find and"% "in wildcards. Where the former "%" number is a character, after "%" is a wildcard)

ESCAPE Specifies the character that represents the escape, as specified above '! ' is an escape character.

SELECT * from Yuesubiao where book_name book_name like ' Kill!_% ' escape '! '

(3) SELECT * from staff where employee number + warehouse number like '%3% '

Equivalent to select * FROM employee where worker number like '%3% or warehouse number like '%3% '

SQL wildcard characters