u can combine like operator in multiple condition

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