Requesting these here, since I'm not quite sure how to go about it via
the WIKI (do you simply edit the request list there and prepend|append
your request to the list?)
1. An IFEMPTY(a,b) operator would be a convenience, analogous to
IFNULL(a,b). It would return the first non-null, non-empty-string value
from the choices a,b.
2. I see that SQLite has already implemented a LIKE(a,b) function., so
the name for this request can't be the ideal one.
Just as the WHERE COLUMN IN(VAL1, VAL3, VALn, ...) function compares the
value in COLUMN against the items in the IN(...) list, and returns TRUE
if any of them are equal to it (a shorthand form of COLUMN=VAL1 OR
COLUMN=VAL2 OR COLUMN=VAL3), I would like to have a function that does a
standard LIKE comparison against a list of values:
where COLUMN MATCHES('anthro%','paleo%','%morph%').
This avoids having to repeat the column name over and over with many OR
operators.
Thanks
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
