X DevAPI User Guide for MySQL Shell in Python Mode

10.1.1 Boolean Expression Strings

Boolean expression strings can be used when filtering collections or tables using operations, such as find() and remove(). The expression is evaluated once for each document or row.

The following example of a boolean expression string uses find() to search for all documents with a red color attribute from the collection apples:

apples.find('color = "red"').execute()

Similarly, to delete all red apples:

apples.remove('color = "red"').execute()