Menu
Community /Pin to ProfileBookmark
@NogDogDec 04.2010 — #You can do an [b]ORDER BY RAND() LIMIT 1[/b], though that can be rather inefficient if you have a lot of rows (for some undefined value of "a lot"). If you Google for something like "mysql alternatives to order by rand", you'll likely come up with some other more advanced options that may be more efficient.
image stored in mysql rand pull
I want to store the image file in mysql as a blob then randomly pull an image from the table to be shown on the page.
Can anyone direct me to something in the manual or help with direction? Thanks
Sign in
to post a comment1 Comments(s) ↴
0
@NogDogDec 04.2010 — #You can do an [b]ORDER BY RAND() LIMIT 1[/b], though that can be rather inefficient if you have a lot of rows (for some undefined value of "a lot"). If you Google for something like "mysql alternatives to order by rand", you'll likely come up with some other more advanced options that may be more efficient.