wildcard characters in SQL Server

Use of wildcard characters in SQL Server

Wildcard characters _

The "_" number represents any single character, and the symbol can match only one character. " _ "can be placed anywhere in the query condition and can only represent one character." A Chinese character is represented by only one "_".

Wildcard character%

The "%" symbol is a character match that can match a string of any length of 0 or more characters. In an SQL statement, you can place a% at any point in the query condition to represent a string of any length. You can also place two% queries when querying conditions, but it's best not to have two% in the query condition

wildcard characters []

"[]" can be used to query a certain range of data in a schema query. [] To specify any single character within a range, including both ends of the data

wildcard characters [^]

[^] is used to query any single character that does not belong to the specified range ([a-f]) or set ([abcdef]).

Such as:

SELECT * FROM Websitespaddingoff
Where URL like ' http[^:]% '

Represents a query from the table websitespaddingoff that the URL begins with HTTP and the second character is not: information.

wildcard characters in SQL Server