Mysql execute query with on-the-fly values

Question

Good day,

I have a practical mysql question to which I can't find help online.

Let's say I have a simple array of values "apple, pear, onion, ananas, banana, coconuts"

and that I would like to use mysql dynamically to, for example, sort, count or group those values.

Is it possible to do something like

SELECT COUNT FROM ("apple", "pear", "onion", "ananas", "banana", "coconuts")

? (of course I tried this and other syntaxes already, to no avail)

Basically what I'm trying to understand if it's possible to avoid creating a table for such a 'simple' task and set of values.

Thanks.

Maxim Krizhanovsky · Accepted Answer · 2012-03-12 16:09:29Z

2

Not sure if shorter syntax exists:

SELECT COUNT(*) FROM (
SELECT "apple"
UNION SELECT "pear"
UNION SELECT "onion"
UNION SELECT "ananas"
UNION SELECT "banana"
UNION SELECT "coconuts" ) t

answered Mar 12, 2012 at 16:09

Maxim Krizhanovsky

26.8k5 gold badges62 silver badges91 bronze badges

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

1 Comment

Ben English Over a year ago

UNION ALL will be slightly longer syntax but fractionally faster performance.

Collectives™ on Stack Overflow

Mysql execute query with on-the-fly values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related