randomquote select

SELECT message
          FROM chatlogs AS r1 JOIN
               (SELECT CEIL(RAND() *
                             (SELECT MAX(id)
                                FROM chatlogs)) AS id)
                AS r2
         WHERE r1.id >= r2.id
         AND channel = ?
         AND username = ?
         AND LENGTH(message) < 200
         ORDER BY r1.id ASC
         LIMIT 1000