Between
" - " symbol is used to select result between two values. The values should be numbers only.
Sql
Select * From Table_Name
Where
Column_Name Between value1 and value2;
JsStore
const results = await connection.select({
from: "Table_Name",
where: {
Column_Name: {
'-': {
low: low-value,
high: high-value
}
},
}
});
//results will be array of objects.
console.log(results);