On Mon, Dec 5, 2016 at 4:24 PM, Igor Tandetnik <i...@tandetnik.org> wrote:
> On 12/5/2016 10:19 AM, Igor Tandetnik wrote: > >> On 12/5/2016 7:30 AM, ravi.shan...@cellworksgroup.com wrote: >> >>> 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. >>> >> >> WHERE length(replace(replace(replace(name, 'Araya', ''), 'Amul', ''), >> 'Aj', '')) != length(name) >> > > Actually, this is not quite the same: it's case-sensitive, whereas LIKE is > case-insensitive by default. To be equivalent, make it > > WHERE length(replace(replace(replace(lower(name), 'araya', ''), 'amul', > ''), 'aj', '')) != length(lower(name)) Or use the pragma [1]. Thanks, didn't realize/know LIKE was case-insensitive (for ASCII chars only) by default, in SQLite. Also made me double-check whether Oracle is case-sensitive or not (it is) [2] BTW, Igor: wow :) Not that I'd use that ever, but still, very clever! --DD [1] https://www.sqlite.org/pragma.html#pragma_case_sensitive_like [2] http://stackoverflow.com/questions/5391069/case-insensitive-searching-in-oracle _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
