GoFuckYourself.com - Adult Webmaster Forum - View Single Post

icedemon · 01-25-2004, 12:19 PM

Have you tried using the GROUP BY function? I think you could do something like this

SELECT text,url FROM table WHERE text LIKE '%something%' GROUP BY surl LIMIT 5

You might have to group both the surl and text
GROUP BY surl, text

01-25-2004, 12:19 PM
icedemon Confirmed User Join Date: Jun 2003 Location: Lutz, FL Posts: 1,022	Have you tried using the GROUP BY function? I think you could do something like this SELECT text,url FROM table WHERE text LIKE '%something%' GROUP BY surl LIMIT 5 You might have to group both the surl and text GROUP BY surl, text __________________ Clips4Sale.com