# HG changeset patch # User Aurelien Campeas # Date 1255624984 -7200 # Node ID 421fb447ecb2bfe72228581d19703a80a7e96b3f # Parent 859f7d741bfb17eb9afe43d4a74606895e6de7e3# Parent d44b170169449e198c78e23893354ca0c542212f merge diff -r 859f7d741bfb -r 421fb447ecb2 doc/book/en/annexes/rql/language.rst --- a/doc/book/en/annexes/rql/language.rst Thu Oct 15 18:34:20 2009 +0200 +++ b/doc/book/en/annexes/rql/language.rst Thu Oct 15 18:43:04 2009 +0200 @@ -11,13 +11,9 @@ :: - DISTINCT, INSERT, SET, DELETE, - WHERE, AND, OR, NOT, EXISTS, - IN, LIKE, UNION, WITH, BEING, - TRUE, FALSE, NULL, TODAY, NOW, - LIMIT, OFFSET, - HAVING, GROUPBY, ORDERBY, ASC, DESC - + AND, ASC, BEING, DELETE, DESC, DISTINCT, EXISTS, FALSE, GROUPBY, + HAVING, ILIKE, IN, INSERT, LIKE, LIMIT, NOT, NOW, NULL, OFFSET, + OR, ORDERBY, SET, TODAY, TRUE, UNION, WHERE, WITH Variables and Typing ~~~~~~~~~~~~~~~~~~~~ @@ -76,7 +72,7 @@ ```````````````````` :: - =, <, <=, >=, >, ~=, IN, LIKE + =, <, <=, >=, >, ~=, IN, LIKE, ILIKE * The operator `=` is the default operator. @@ -88,6 +84,8 @@ Any X WHERE X name ~= 'Th%' Any X WHERE X name LIKE '%lt' +* The operator `ILIKE` is the case insensitive version of `LIKE`. + * The operator `IN` provides a list of possible values: ::