What operator performs pattern matching?

LIKE operator

Showing Answers 1 - 3 of 3 Answers

sk

  • Aug 31st, 2005
 

% operator

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

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.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions