mysql query

[Quentin Cotillard <quentin@xxxxxxxxxxxxxxxx>]

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?

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php