select random example

-- Select at Random
SELECT c.Answer, u.username, p.Name, p.Surname, p.City, p.Town, p.PostCode FROM mbfTools_Competitor c
JOIN MBF_DB_1.dbo.aspnet_Profile p
ON c.UserId = p.UserId
JOIN MBF_DB_1.dbo.aspnet_Users u
ON c.UserId = u.UserId
WHERE c.competitionid = 172 
AND c.answer LIKE '%As little as three minutes%'
ORDER BY NEWID()