diff -r 6f807804f1d0 -r d44b17016944 doc/book/en/annexes/rql/language.rst --- a/doc/book/en/annexes/rql/language.rst Thu Oct 15 15:28:10 2009 +0200 +++ b/doc/book/en/annexes/rql/language.rst Thu Oct 15 17:12:47 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: ::