mysql query

From:	Quentin Cotillard	Date:	Fri, 13 Aug 2004 13:20:36 +0000
Subject:	mysql query
Groups:	php.db
Request:	Send a blank email to php-db+get-35688@lists.php.net to get a copy of this message

Consider a table similar to the one below. What I want to do is to get ONE random record from categories(cat) A and 5 random record from category B | ID | computer | name | cat |...

  1	dell	   834    A
  2	ibm	   526    A
  3	apple	   134    B
  4	sony	   333    A
  5	dell	   834    B
  6	ibm	   556    A
  7	apple	   534    B
  8	sony	   233    A
  9	dell	   874    A

... How could I construct my query to the mysql?