mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 19:09:41 +00:00
18 lines
352 B
Plaintext
18 lines
352 B
Plaintext
|
|
SELECT upper(char(0xfb04,0xfb04,0xfb04,0xfb04));
|
|
|
|
|
|
DROP TABLE IF EXISTS t1;
|
|
CREATE TABLE t1(id INTEGER PRIMARY KEY, x TEXT);
|
|
INSERT INTO t1 VALUES
|
|
(1,'abcde'),
|
|
(2,'abc_'),
|
|
(3,'abc__'),
|
|
(4,'abc%'),
|
|
(5,'abc%%');
|
|
SELECT id FROM t1 WHERE x LIKE 'abc%%' ESCAPE '%';
|
|
|
|
|
|
SELECT id FROM t1 WHERE x LIKE 'abc__' ESCAPE '_';
|
|
|