table Articles - id (int) - category (varchar) - title (varchar) - image (varchar) - link (varchar) - Counter (int) - dateStamp (datetime)
SELECT r1.* FROM Articles AS r1 INNER JOIN (SELECT(RAND() * (SELECT MAX(id) FROM Articles)) AS id) AS r2 WHERE r1.id >= r2.id AND r1.category = 'entertainment' LIMIT 6;
Order by newid()
Use below code. <pre>Order by newid()</pre>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)