Hi, My Table
No | Type | ID 1 v 3233 2 h 5123 3 v 1345 4 v 5457 5 h 8756 6 h 8757 7 v 8067 Select random "No" (i know rand()) Select two row (i know limit 0,2) Select Type v,h or h,v but dont want v,v or h,h Example Result i want 5 h 8756 7 v 8067 Or 1 v 3233 6 h 8757 But i dont want 1 v 3233 7 v 6067 or 5 h 8756 6 h 8757 Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]