PHP/MySQL - Select RANDOM value from column where another column equals value

Question

I feel like my question is extremely basic and has been answered before but I just can't seem to find anything about it.

Let's say I have a column named 'Names' and another called 'Level'.

-----------------------
 Names   |   Level
-----------------------
Scooby   |     3
Daphne   |     1
Shaggy   |     2
Fred     |     3
Velma    |     2
Scrappy  |     0

Basically I need a random name from the 'Names' column where 'Level' = 2. In this case randomly Shaggy or Velma. In reality the database will probably be in the dozens if not hundreds of the same 'Level' value.

I've seen code using:

SELECT column FROM table
ORDER BY RAND()
LIMIT 1

And I've tried playing with WHERE in there but with no success. Any ideas? Using PHP to fetch the data from MySQL to return to a Flash file. I apologize for the simplicity of the question.

Mitch Wheat · Accepted Answer · 2013-08-05 04:11:46Z

3

SELECT Names FROM table1
where Level = 2
ORDER BY RAND()
LIMIT 1

SQL Fiddle

answered Aug 5, 2013 at 4:11

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

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

1 Comment

Mitch Wheat Over a year ago

@smcjones: your comment makes no sense. This SQL works because that's the way it is written.

Becs Carter · Accepted Answer · 2013-08-05 04:10:07Z

0

Have you tried this?

SELECT `Names` FROM `table_name`
WHERE `level` = 2
ORDER BY RAND()
LIMIT 1

answered Aug 5, 2013 at 4:10

Becs Carter

1,2501 gold badge12 silver badges27 bronze badges

Collectives™ on Stack Overflow

PHP/MySQL - Select RANDOM value from column where another column equals value

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related