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 (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
test 16721723
MovieRating SQL
PostgresInsertIfNotExists
PostgreSQL Sandbox: Legitimate Resale
m,,nm,
Pedido
SQL2_CLASS
Sush_post1
Persy_Jackson
Leetcode 571 Find Median Given Frequency of Numbers & 614 Second Degree Follower