Using LIKE operator in multiple condition

[debasisdas]

LIKE operator is used for pattern matching you can combine multiple statments for different conditions using logical operators.

[mehta_hetal]

u can combine like operator in multiple condition

for eg. where (name like 'abc%' or name like 'pqr%');