db and

Includes an AND clause for a query or expression

Signature

> db and (where)

Parameters

  • where: Where expression on the table

Examples

selects a column from a database with a where clause

> db open db.mysql
    | db select a
    | db from table_1
    | db where ((db col a) > 1)
    | db and ((db col b) == 1)
    | db describe

Creates a nested where clause

> db open db.mysql
    | db select a
    | db from table_1
    | db where ((db col a) > 1 | db and ((db col a) < 10))
    | db describe