GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Tech Quick PHP question, random data and limits

k0nr4d · 12-20-2021, 12:07 AM

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

12-20-2021, 12:07 AM
k0nr4d Confirmed User Industry Role: Join Date: Aug 2006 Location: Poland Posts: 9,228	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 __________________ Mechanical Bunny Media Mechbunny Tube Script \| Mechbunny Webcam Aggregator Script \| Custom Web Development