bing
Flat 10% & upto 50% off + Free additional Courses. Hurry up!
×
UPTO
50%
OFF!

LIKE Operator

 

It is used to search a specified pattern in a column. The two wildcards operator used in conjunction with the LIKE operator.

  • % – The percent sign is used to represent one or more characters.
  • _ – The underscore sign is used to represent only one Character.

Syntax:

SELECT column1, column2….

FROM table_name

WHERE column1 LIKE %XXX;

‘OR’

SELECT column1, column2….

FROM table_name

WHERE column1 LIKE %XXX%;

‘OR’

 

SELECT column1, column2….

FROM table_name

WHERE column1 LIKE _XXX;

‘OR’

SELECT column1, column2….

FROM table_name

WHERE column1 LIKE XX_X;

‘OR’

SELECT column1, column2….

FROM table_name

WHERE column1 LIKE %XX_X;

Example:

SELECT Name, Roll_no

FROM Student_details

WHERE Name LIKE %tesh;

 

Name Roll No.
Jitesh 6

"0 Responses on LIKE Operator"

100% Secure Payments. All major credit & debit cards accepted Or Pay by Paypal.
top

Sales Offer

  • To avail this offer, enroll before 30th April 2017.
  • This offer cannot be combined with any other offer.
  • This offer is valid on selected courses only.
  • Please use coupon codes mentioned below to avail the offer
offer-june

Sign Up or Login to view the Free LIKE Operator.