Hey Folks, I have a query where it pulls random data and display's it.
SELECT route_photo, route, route_count, area FROM routes WHERE ???? ORDER BY RAND() LIMIT 1
The query works fine, however, the "route_photo" field is partially populated. This results in just a "route" name appearing but no photo. How can I change the query to only pull up "routes" that have a "route_photo" listed in the DB?
Thanks, CH
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
