developerdino/REST Laravel database grammar.md

## REST Laravel database grammar.md

      
    Raw
  

              REST Laravel database grammar.md
            
          
    REST API Data Query Grammar

WHERE

GET /{tablename}?where[<column>][]=o:<operator>;v:<value>
WHERE BETWEEN / WHERE BETWEEN COLUMNS

GET /{tablename}?whereBetween[<column>]=v:<value 1>,<value 2>
WHERE BITWISE

GET /{tablename}?whereBitwise[<column>][]=o:<operator>;v:<value>
WHERE COLUMN

GET /{tablename}?whereColumn[<column 1>:<column 2>]=o:<operator>
WHERE DATE

GET /{tablename}?whereDate[<column>]=v:<date>
WHERE DAY

GET /{tablename}?whereDay[<column>]=v:<day>
WHERE EXISTS

GET /{tablename}?whereExists[<tablename 2>][<column 1>:<column 2>]
WHERE FULL TEXT

GET /{tablename}?whereFullText[<column 1>:<column 2>:<column n>]=v:<value>;m:<0|1>;e:<0|1>
WHERE IN

GET /{tablename}?whereIn[<column>][]=v:<value 1>,<value 2>,<value n>
WHERE JSON BOOLEAN

GET /{tablename}?whereJsonBoolean[<column>][]=o:<operator>;v:<value>
WHERE JSON CONTAINS

GET /{tablename}?whereJsonContains[<column>][]=n:<not>;v:<value>
WHERE JSON CONTAINS KEY

GET /{tablename}?whereJsonContainsKey[<column>][]=n:<not>
WHERE JSON LENGTH

GET /{tablename}?whereJsonLength[<column>][]=o:<operator>;v:<value>
WHERE MONTH

GET /{tablename}?whereMonth[<column>]=v:<month>
WHERE NOT EXISTS

GET /{tablename}?whereNotExists[<tablename 2>][<column 1>:<column 2>]
WHERE NOT IN

GET /{tablename}?whereNotIn[<column>][]=v:<value 1>,<value 2>,<value n>
WHERE NOT NULL

GET /{tablename}?whereNotNull[<column>]=1
WHERE NULL

GET /{tablename}?whereNull[<column>]=1
WHERE ROW VALUES

GET /{tablename}?whereRowValues[<column 1>,<column 2>,<column n>]=v:<value 1>,<value 2>,<value n>
WHERE SUB

GET /{tablename}?whereSub[<column>]=q:????
WHERE TIME

GET /{tablename}?whereTime[<column>]=v:<time>
WHERE YEAR

GET /{tablename}?whereYear[<column>]=v:<year>