Skip to main content

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);

Example