SQL LIKE

Send request to get interview tips in PDF format Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks You can also get your answers published How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite CareerRide is hiring

SQL LIKE - Introduction and syntax

---

<<Previous  Next>>

SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai

Explain the SQL LIKE statement. Write SQL syntax for the SQL LIKE statement along with an example.

LIKE clause is used for pattern matching. % is used to match any string of any length where as _ allows you to match on a single character.

Syntax:
SELECT * FROM table_name WHERE column_name like 'pattern%';

Example:
SELECT * FROM employee WHERE emp_name like 'ma%';

<<Previous  Next>>