mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-05-23 02:28:13 +00:00
26 lines
573 B
Plaintext
26 lines
573 B
Plaintext
|
|
||
|
|
CREATE TABLE t1(x);
|
||
|
|
INSERT INTO t1 VALUES('b');
|
||
|
|
INSERT INTO t1 VALUES('B');
|
||
|
|
|
||
|
|
|
||
|
|
SELECT * FROM t1 WHERE x COLLATE nocase BETWEEN 'a' AND 'c';
|
||
|
|
|
||
|
|
|
||
|
|
SELECT * FROM t1 WHERE x BETWEEN 'a' COLLATE nocase AND 'c' COLLATE nocase;
|
||
|
|
|
||
|
|
|
||
|
|
SELECT * FROM t1
|
||
|
|
WHERE x COLLATE nocase BETWEEN 'a' COLLATE nocase AND 'c' COLLATE nocase;
|
||
|
|
|
||
|
|
|
||
|
|
SELECT * FROM t1 WHERE +x COLLATE nocase BETWEEN 'a' AND 'c';
|
||
|
|
|
||
|
|
|
||
|
|
SELECT * FROM t1 WHERE +x BETWEEN 'a' COLLATE nocase AND 'c' COLLATE nocase;
|
||
|
|
|
||
|
|
|
||
|
|
SELECT * FROM t1
|
||
|
|
WHERE +x COLLATE nocase BETWEEN 'a' COLLATE nocase AND 'c' COLLATE nocase;
|
||
|
|
|