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

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"

Training in Cities

Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Chicago, San Francisco, Dallas, Washington, New York, Orlando, Boston

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

top

Sales Offer

  • To avail this offer, enroll before 05th December 2016.
  • 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.