Hi Guys,
select name from employee table where name like '%Araya%' or name like
'%Amul%' or name like '%Aj%';
Table - Employee
Id | Name | age |
1 | Arayan Kuma | 29 |
2 | Amul Kanth | 30 |
3 | Ajay Kumar | 45 |
I dont like to use may or conditions for pattern matching using like
operator.
Is there any other way I can workaround without using or condition in
like operator in sqlite.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
