$db.get
Get the value of the designated column
Note: $db.get method is available in the Advanced Edition only.
Syntax:
$db.get( str, columnIndex )
Parameters:
str – a result of $db.query columnIndex – the index of the column
Returns:
the column value
Version Since:
3.8
Example:
$db.get($db.query("mydb", "SELECT value FROM table WHERE key='%1')"),"2") = (.+)
Execute SELECT statement on the databse “mydb” and get the value of the second column.