Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Query integer in text field - Seemingly doesn't work as expected
CREATE TABLE texts ( id integer NOT NULL, title character varying(1000) DEFAULT NULL::character varying ); INSERT INTO texts VALUES (1129, 'Text 1129'); INSERT INTO texts VALUES (1130, 'Text 1130'); INSERT INTO texts VALUES (1131, 'Text 1131'); INSERT INTO texts VALUES (1132, 'Text 1132'); INSERT INTO texts VALUES (2233, 'Text 1133'); INSERT INTO texts VALUES (2234, 'Text 1134'); INSERT INTO texts VALUES (2235, 'Text 1135'); INSERT INTO texts VALUES (2236, 'Text 1136'); SELECT * FROM texts WHERE title LIKE '%' || id - 1000 || '%' ORDER BY id;
run
|
edit
|
history
|
help
0
-
by Shenk, 2 years ago
Please
log in
to post a comment.
Joins and Case
testo
loggin_trigger-audit
Assignment 1(SET A)
SQL Moving Rating Practice by Han Wang 20200720
funkcia_transakcie
proj
hw
Assignment 1(SET A)
Query workaround in order to avoid IN Operator in WHERE Clause
-
by Shenk, 2 years agoPlease log in to post a comment.