>is anybody aware of a possibility to do s.th. like
>select * from table where field like '[A|a]%'
Unless non-standard compile option and provided you don't issue
PRAGMA case_sensitive_like = 1;
LIKE is case-insensitive, so LIKE 'A%' is the same as LIKE 'a%'
SQLite offers another filtering function: GLOB, which is case-sensitive
and can accept '*', '?' wildcards (instead of LIKE' % and _) and a
regexp-style character subset for selection '[a-z]' or exclusion '[^0-9]'.
select 'abcd123' glob '*[Cc]?[1-9]2*';
1
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
