output

SELECT IN (SET)

CLI=./redisql-server
$CLI CREATE TABLE data "(id INT, val TEXT)"
$CLI INSERT INTO data VALUES "(1,ONE)"
OK
$CLI INSERT INTO data VALUES "(2,TWO)"
OK
$CLI INSERT INTO data VALUES "(3,THREE)"
OK
$CLI INSERT INTO data VALUES "(4,FOUR)"
OK
$CLI INSERT INTO data VALUES "(5,FIVE)"
OK
$CLI SADD set1 1
(integer) 1
$CLI SADD set1 2
(integer) 1
$CLI SADD set1 3
(integer) 1
$CLI SADD set2 3
(integer) 1
$CLI SADD set2 4
(integer) 1
$CLI SADD set2 5
(integer) 1
$CLI SELECT "*" FROM data WHERE "id IN (\$SMEMBERS set1)"
1. "3,THREE"
2. "1,ONE"
3. "2,TWO"
$CLI SELECT "*" FROM data WHERE "id IN (\$SINTER set1 set2)"
1. "3,THREE"
$CLI SELECT "*" FROM data WHERE "id IN (\$SUNION set1 set2)"
1. "3,THREE"
2. "4,FOUR"
3. "1,ONE"
4. "2,TWO"
5. "5,FIVE"