Devo LINQ, query language syntax Cheat Sheet by elpluto

from my.app.we­b.auth

select source­_column or column operation as destination_column
select uriHos­t(uri) as host

 every period

Period syntax: an integer number follow by a symbol indicating the time period:[s:sec­onds, m:minutes, h:hours, d:days, no suffix­:mi­lli­sec­onds]

every 0 means no client period.

every 5m by serverIp 


decode(column, checkV­alue, value,­[ch­eck­Value2, value2])

Each pair of arguments [check­Value, value] is equivalent to a case sentence of a switch statement. 

decode(statu­sCode, 200, "­Suc­ces­s", 400, "Not Found", 406, "­Err­or", 404, "­Err­or") as status­Cod­eDesc


avg(column); nnavg(column) 


first(column); nnfirst(column) 


max/min(col1, [col2], [col3]…) 


sum(column) 


percen­tile[N](column) 


ustdde­v/u­nns­tddev(column) 

Unbiased 


uvar/u­nnvar(column)

Unbiased 


hllppcount(column)

Applies on float or integer data types. 


has(column, value1, [value2],…)

column -> value1 

 in(value1, [value­2],­[...], column)
 value1 <- column

starts­wit­h(c­olumn, value)

toktai­ns(­column, value, [bool_­left], [bool_­right])

locate­(co­lumn, substr­ing­_to­Locate)

upper(­column)

replac­eal­l(c­olumn, string­ToS­earch, string­ToR­eplace)

 pieceN­umber begin at 0.
 splitr­e(c­olumn, re(string) or regexp, pieceN­umber)

 FailValue is returned when is provided and no occurr­ences found
 subs(c­olumn, regexp, template, [failValue])
 subs(c­olumn, re(str­ing), templa­te(­str­ing), [failV­alue])

trim(c­olumn)

rtrim(­column)

 If no partNumber is provided then returns first part occurrence.
peek(column, re(string) or regexp, [partN­umber])

damera­u(c­olumn, value)

levens­hte­in(­column, value)

publicsuffix(hostnameColumn))
  'www.m­y.s­ite.co.uk' = 'co.uk'

rootpredix(hostnameUrlColumn))
  'www.m­y.s­ite.com' = 'www.m­y.site'

subdomain(hostnameUrlColumn)
  'www.m­y.s­ite.com' = 'www'

24.256

yyyy-MM-dd HH:mm:­ss.SSS

 [d]ays, [h]ours, [m]inutes, [s]econds, [No suffix­]:m­ill­ise­conds

 192.16­8.5.56

{x.x.x.x/0

 [^\w]

 00:0a:­95:­9d:­68:16

 {my.ap­p.test, my.app.test2}

 .email

 eq(column, value or column)
 column1 = value or column

 ge(column, value or column)
 column >= value or column

 le(column, value or column)
 column <= value or column

 ne(column, value or column)
 column /= value or column

isnotn­ull­(co­lumn)

matche­s(c­olumn, re(string) or regexp value)
column ~ re(string) or regexp value

namegl­ob(­string)