forked from Nicklas766/MySQL-JSONify
-
Notifications
You must be signed in to change notification settings - Fork 1
Filter
Turan Furkan Topak edited this page Oct 11, 2020
·
4 revisions
- "lk": LIKE
- "nlk": NOT LIKE
- "cs": contain string (string contains value)
- "ncs": not contain string (string not contains value)
- "sw": start with (string starts with value)
- "ew": end with (string end with value)
- "eq": equal (string or number matches exactly)
- "neq": not equal (string or number matches exactly)
- "lt": lower than (number is lower than value)
- "le": lower or equal (number is lower than or equal to value)
- "ge": greater or equal (number is higher than or equal to value)
- "gt": greater than (number is higher than value)
- "bt": between (number is between two comma separated values)
- "nbt": not between (number is not between two comma separated values)
- "in": in (number or string is in comma separated list of values)
- "nin":not in (number or string is not in comma separated list of values)
- "is": is null (field contains "NULL" value)
- "nis": is not null (field bot not contains "NULL" value)
Footer