The WHERE clause specifies search conditions, that remove unwanted data from the query result. The following operators, are in order of precedence. The operators are evaluated in the specified order:
SELECT * FROM java.lang.String s WHERE s.count >= 100
SELECT * FROM java.lang.String s WHERE toString(s) LIKE ".*day"
SELECT * FROM java.lang.String s WHERE s.value NOT IN dominators(s)
SELECT * FROM java.lang.String s WHERE toString(s) = "monday"
SELECT * FROM java.lang.String s WHERE s.count > 100 AND s.@retainedHeapSize > s.@usedHeapSize
SELECT * FROM java.lang.String s WHERE s.count > 1000 OR s.value.@length > 1000
Operators can be applied to expressions, constant literals and sub queries. Valid expressions are explained in the next sections.
Boolean, String, Integer, Long and null literals:
SELECT * FROM java.lang.String s WHERE ( s.count > 1000 ) = true WHERE toString(s) = "monday" WHERE dominators(s).size() = 0 WHERE s.@retainedHeapSize > 1024L WHERE s.@GCRootInfo != null