sk

• Aug 31st, 2005

 

% operator

Vijay Raj Jaiswal

• Sep 20th, 2005

 

Like operator.

It is used with  % and_
% means starts or ends with enything If we want to dispay name ends with jay
select name from employee where nam like '%jay%';
Ooutput: Name
         ------
         Vijay
          Ajay
         Sanjay
         sujay 
_ is used with like for exact pattern matching
EX:select name from emp where name like'__jay';
Output: name
        -----
        vijay  
        sujay

sankar

• Sep 21st, 2005

 

like

mehraban_b

 Profile Answers by mehraban_b 

• Mar 14th, 2007

 

%

pujavipin

 Profile Answers by pujavipin 

• Jun 4th, 2009

 

LIKE operator can be used in a WHERE clause to search for a particular pattern from columns in a table.

Syntax:
 SELECT column_name(s) from table_name WHERE column_name LIKE pattern.