How to work with SQL Like Operator

The LIKE operator is used to list all rows in a table whose column values match a specified pattern. It is used with %(wildcard) operator.

Syntax :

SELECT (column name) FROM table_name
 WHERE (column name) LIKE pattern;
-we can use the %(wildcard) in the pattern. Let's create the table we will use for our examples:

Script:

--first lets drop the table Test (if she exists, if not skip the drop line).
Drop table test;
create table test (id int,name varchar(20),email varchar(20),salary int ,de char(20));
--insert values into table
insert into test values (1,'Eve','[email protected]',1500,'HR');
insert into test values (2,'Jon','[email protected]',2500,'AD');
insert into test values (3,'Mike','[email protected]',3000,'AD');
insert into test values (4,'Paul','[email protected]',3200,'HR');
insert into test values (5,'Mary','[email protected]',1800,'IT');
insert into test values (6,'Jane','[email protected]',2200,'IT');
Check the table to see the data and the structure. 
SQLselect * from test ;
    ID NAME         EMAIL            SALARY  DE
 ---------- -------------------- -------------------- ---------- --  --------
     1  Eve         [email protected]       1500   HR
     2  Jon         [email protected]       2500   AD
     3  Mike       [email protected]        3000   AD
     4  Paul        [email protected]       3200   HR
     5  Mary       [email protected]        1800   IT
     6  Jane        [email protected]       2200   IT
Very good

Example 1 :

-with no %(wildcard) pattern. 
SQLselect name from test where name like 'Eve';
NAME
--------------------
Eve

Example 2 :

-with %(wildcard) pattern. 
SQLselect name from test where name like '%ve';
NAME
--------------------

Eve

SQLselect name from test where name like 'Mi%';

NAME

--------------------


Mike

SQLselect name from test where name like '%k%';

NAME

--------------------


Mike

Copyright 2020. All Rights Reserved