Database
Scalar

Scalar

Returns the first column for a single row

Database.scalar(query, data, cb)
  • query: string
  • data?: table
  • cb?: function(result)

returns: any

local column1 = Database.scalar('SELECT `column1` FROM `table` WHERE `column3` = ? LIMIT 1' , { 'value1' })
 
print(column1)