Skip to main content

And

The AND operator is used with the WHERE clause in SQL to filter records based on multiple conditions. It allows you to specify multiple conditions that must all be true for a record to be included in the result set.

SQL​

Select * From Table_Name
Where
Column1=some_value
and
Column2=some_another_value;

JsStore​

var results = await connection.select({
    from: "Table_Name",
    where: {
        column1: some_value,
        column2: some_another_value
    }
});
console.log(results);

Example

Alternative syntax​

An alternative syntax for using the AND operator in a query is to use an array for each column condition. This approach simplifies the query structure and enhances readability.

var results = await connection.select({
    from: "Table_Name",
    where: [
        {
            column1: some_value
        },
        {
            column2: some_another_value
        }
    ]
});
console.log(results);