MySQL select from specific values

Question

I'm trying to do a query that will turn a list of literal values into a result set, but I can't quite figure out the syntax without doing a union.

Here are a couple things I've tried:

SELECT *
FROM (1, 2, 3, 5, 6) temp(id);

select x.* from 
(('test-a1', 'test-a2'), ('test-b1', 'test-b2'), ('test-c1', 'test-c2')) x(col1, col2);

Something like that where I'm expecting a result set that looks like:

id
1
2
3
4
5
etc…

or

col1 | col2
test-a1, test-a2
test-b1, test-b2
test-c1, test-c2
etc…

Taylor McKay · Accepted Answer · 2018-10-17 17:48:52Z

1

CREATE TEMPORARY TABLE temp_id_table
( id INT UNSIGNED NOT NULL );

INSERT INTO temp_id_table ( id ) VALUES
(1),(2),(3),(4),(5)
;

select id from temp_id_table;

results:

answered Oct 17, 2018 at 17:48

Taylor McKay

262 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SDr6 · Accepted Answer · 2018-10-17 17:48:10Z

0

Create a temp table, insert those values to the temp table then query your temp table.

answered Oct 17, 2018 at 17:48

SDr6

213 bronze badges

Collectives™ on Stack Overflow

MySQL select from specific values

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related