Parameters

Other paramaters for the where condition and other filtering methods

Parameter
Operator
Description

eq

=

Equal

in

in (...)

In

gt

>

Greater than

gte

>=

Greater than or equal

lt

<

Less than

lte

=

Less than or equal

like

like "%..%"

Like

between

between '..' and '..'

Between

or

($ = '' or $1 = '')

Or

and

($ = '' and $1 = '')

And

limit

LIMIT

Limit

group

GROUP BY ...

Group By

having

HAVING ...

Having

offset

OFFSET

Offset

Last updated