View Single Post
Old 12-20-2021, 12:35 AM  
Publisher Bucks
Confirmed User
 
Industry Role:
Join Date: Oct 2018
Location: New Orleans, Louisiana. / Newcastle, England.
Posts: 1,123
Quote:
Originally Posted by k0nr4d View Post
Null and empty are not the same thing. Null is used to refer to nothing and empty is a string with zero length.


SELECT * FROM table WHERE column != '' ORDER BY RAND() LIMIT 1
Okay that works, thank you.

Any chance you could explain why for me though? What does that != do that a regular query doesnt?
__________________
NOTHING TO SEE HERE
Publisher Bucks is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote