Like Operator

Advertisements

Prev Tutorial Next Tutorial

Like Operator in SQL

Like Operator is used in a WHERE clause to search for a specified pattern in a column. Suppose you want to search those employee record whose name start with H alphabet.

Syntax

SELECT column_name
FROM table_name
WHERE column_name LIKE pattern;

Employee table

emp_idnamesalary
101Amit24000
102Rahul34000
103Sultan54000
104Gaurav26000
105Hitesh35000

Example

SELECT * from Employee
WHERE name LIKE 'H%';

Result after using Like Operator.

105Hitesh35000

Prev Tutorial Next Tutorial

Advertisements

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 8076671483

Pure VPN Privide Lowest Price VPN Just @ $1.65. Per Month with Non Detected IP Lowest Price Non Detected IP VPN

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

Download Projects

Google Advertisements


Buy Websites 9999595223

Buy Fresh and Payment Receive Media.net Account with Website. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements