Open eznix86 opened 5 months ago
OR
OR operator is discussed here -> #66
LIKE
{"startsWith": "John"}
creates LIKE 'John%'
LIKE 'John%'
{"endsWith": "John"}
creates LIKE '%John'
LIKE '%John'
{"contains": "John"}
creates LIKE '%John%'
LIKE '%John%'
[!NOTE] The current implementation of contains allows %John% to be passed it can be prone to SQL injection
contains
%John%
CASE INSENSITIVE
{"istartsWith": "John"}
{"iendsWith": "John"}
{"icontains": "John"}
Similar as above, but appends collate NOCASE.
collate NOCASE
BETWEEN
{"between": [1, 25]}
IS NULL
{"null": true}
IS NOT NULL
{"notnull": true}
OR
operatorOR operator is discussed here -> #66
LIKE
operatorcreates
LIKE 'John%'
creates
LIKE '%John'
creates
LIKE '%John%'
LIKE
withCASE INSENSITIVE
operatorSimilar as above, but appends
collate NOCASE
.BETWEEN
operatorIS NULL
operatorIS NOT NULL
operator