--- 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:
::