Like Clause In Sql

The SQL LIKE clause is used to compare a value to similar values using wildcard operators. There are two wildcards used in combination with the LIKE 

operator:The percent sign (%)

The underscore (_)

The percent sign represents zero, one, or multiple characters. The underscore represents a single number or character. The symbols can be used in 

combinations.

Syntax:
The basic syntax of % and _ is as follows:
Example:-


SELECT FROM table_name
WHERE column LIKE 'XXXX%'

or 

SELECT FROM table_name
WHERE column LIKE '%XXXX%'

or

SELECT FROM table_name
WHERE column LIKE 'XXXX_'

or

SELECT FROM table_name
WHERE column LIKE '_XXXX'

or

SELECT FROM table_name
WHERE column LIKE '_XXXX_'
You can combine N number of conditions using AND or OR operators. Here,
 XXXX could be any numeric or string value.

Share this

Hemalata