SQL Wildcard

By /

SQL Wildcard operators are used with LIKE operator, there are four basic operators:

Operator Description
% It is used in substitute of zero or more characters.
_ It is used in substitute of one character.
[range_of_characters] It is used to fetch matching set or range of characters specified inside the brackets.
[^range_of_characters] or [!range of characters] It is used to fetch non-matching set or range of characters specified inside the brackets.

Basic syntax:

SELECT column1,column2 FROM table_name WHERE column LIKE wildcard_operator;
column1 , column2: fields in the table
table_name: name of table
column: name of field used for filtering data

Scroll to Top