Comparing

Comparing

In AlaSQL you can use standard comparing operators:

• = != (or <>)

• = < <=

• BETWEEN / [NOT BETWEEN](Not Between)

See the example:

// Fill table with data
var person = [ 
    { name: 'bill' , sex:'M', income:50000 },
    { name: 'sara' , sex:'F', income:100000 },
    { name: 'larry' , sex:'M', income:90000 },
    { name: 'olga' , sex:'F', income:85000 },
];

// Do the query
var res1 = alasql("SELECT * FROM ? person WHERE income = 50000", [person]);
var res2 = alasql("SELECT * FROM ? person WHERE sex='F'", [person]);

You can try this example in jsFiddle