根据特定条件在MySQL数据库中选择随机条目

Question

Alright, let's say my MySQL table is set up with entries similar to:

id  code            sold
1   JKDA983J1KZMN49  0
2   JZMA093KANZB481  1
3   KZLMMA98309Z874  0

I'd like it to pick a random ID within the ranges already in the database (or just go from 1-X) and then just assign it to a variable for my own action to be taken. So let's say we want to pick a code that isn't sold (marked as 0 and not 1), then we'd pick it.

Now, it doesn't have to be 100% random, it could check if the first one is sold, if not, keep going. But I'm not 100% sure on how to go by this. Snippets would be appreciated because I can work out things easily on my own, I just need an example to see where I am going.

Answer 1

How about using a WHERE and ORDER BY RAND()

SELECT id, code
FROM tablename
WHERE sold = 0
ORDER BY RAND()
LIMIT 1