SQL LIKE CLAUSE

The #SQL #LIKE #clause is used to compare a value to similar values using wildcard operators. There are two wildcards used in conjunction 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. These symbols can be used in combinations.

#Syntax The basic syntax of % and _ is as follows −

#SELECT FROM table_name WHERE column LIKE 'XXXX%'

SELECT #FROM table_name WHERE column LIKE '%XXXX%'

SELECT FROM #table_name WHERE column LIKE 'XXXX_'

SELECT FROM table_name #WHERE column LIKE '_XXXX'

SELECT FROM table_name WHERE #column LIKE '_XXXX_'

#Example
The following table has a few examples showing the WHERE part having different LIKE clause with '%' and '_' operators −
WHERE SALARY #LIKE '200%‘ :- Finds any values that start with 200.
WHERE SALARY LIKE '%200%‘ :- Finds any values that have 200 in any position.
WHERE SALARY LIKE '_00%‘ :-Finds any values that have 00 in the second and third positions.
WHERE SALARY LIKE '2_%_%‘:- Finds any values that start with 2 and are at least 3 characters in length.
WHERE SALARY LIKE '%2‘ :- Finds any values that end with 2.
WHERE SALARY LIKE '_2%3‘ :- Finds any values that have a 2 in the second position and end with a 3.
WHERE SALARY LIKE '2___3‘ :- Finds any values in a five-digit number that start with 2 and end with 3.

Following is an example, which would display all the records from the CUSTOMERS table, where the SALARY starts with 200.
SELECT * FROM CUSTOMERS WHERE SALARY LIKE '200%';

#Subscribe the #Channel #Link :- #bansodetechsoluiotn #ajupgrading https://www.youtube.com/c/AjUpgradingBANSODETECHSOLUTION?sub_confirmation=1

IF any #Query or #Doubt #DM on #Instagram :- #bansode_ajay_2102
https://www.instagram.com/bansode_ajay_2102?r=nametag