What is different between Like And IN?

LIKE Operator

Like Operator used to search the expression based on specific pattern.

If we want the specific data but we dont know exactly what it may be then LIKE Operator is used.

select * from TableName where ColumnName Like '%part_of_value%'

IN Operator

IN Operator used to search group of expression

If we want more than one value in where condition IN Operator is used

select * from TableName where ColumnName IN ('value1','value2')

vimalrnsin-17147, if this helps please login to Mark As Answer. | Alert Moderator

LIKE : - Column value's similar to specified character.
IN : - Column value's equal to any one of a specified set of values.

For more details...
http://beginner-sql-tutorial.com/sql-like-in-operators.htm

vimalrnsin-17147, if this helps please login to Mark As Answer. | Alert Moderator

LIKE

Like is used for pattern search.
If you want to know the list of all persons whose firstname starts with peter then use like operator

select * from persons where firstname like 'peter%'

IN

IN operator is much shorter and easier to read when you are testing for more than two or three values.
The IN operator allows you to specify multiple values in a WHERE clause.
SELECT * FROM Persons
WHERE LastName IN ('Hansen','Pettersen')

vimalrnsin-17147, if this helps please login to Mark As Answer. | Alert Moderator

IN:

We can compare more than one column value at a time.

eg: i want data from table where employee name may be mahesh,suresh


select * from employee where ename in('mahesh','suresh')

LIKE:

generally used to work with characters in column.

eg: i want the data from table where employee name starts with m

select * from employee where ename LIKE 'm%'

mahesh

vimalrnsin-17147, if this helps please login to Mark As Answer. | Alert Moderator