Run Code
|
API
|
Code Wall
|
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 (2133, 'Text 1133'); INSERT INTO texts VALUES (2134, 'Text 1134'); INSERT INTO texts VALUES (2135, 'Text 1135'); INSERT INTO texts VALUES (2136, 'Text 1136'); SELECT * FROM texts WHERE title LIKE ('%' || id - 1000 || '%') ORDER BY id;
run
|
edit
|
history
|
help
0
Finale8E9237394
PostreSQL: warehouse table
1075-1077 Project Analysis
pokemo
book suggestion
librarayv2
Returning IDs with exactly 3 consecutive months of invoice_amt >2000
Laidata Practice
Join elements by key with json fields
xD