Re: Simplifying MySql queries
| From: | Simcha Younger | Date: | Mon, 14 Feb 2011 08:43:02 +0000 |
| Subject: | Re: Simplifying MySql queries | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-311275@lists.php.net to get a copy of this message | ||
On Sat, 12 Feb 2011 22:40:27 +0200
Andre Polykanine <andre@oire.org> wrote:
> Hi all,
> I'm using in my PHP script the following four MySql queries:
> $q1=mysql_query("SELECT * FROM
>
CandidateQuestions WHERE
> Category='1' ORDER BY RAND() LIMIT 1");
> $q2=mysql_query("SELECT * FROM
> CandidateQuestions WHERE
> Category='2' ORDER BY RAND() LIMIT 1");
> $q3=mysql_query("SELECT * FROM
> CandidateQuestions WHERE
> Category='3' ORDER BY RAND() LIMIT 1");
> $q4=mysql_query("SELECT * FROM
> CandidateQuestions WHERE
> Category='4' ORDER BY RAND() LIMIT 1");
>
> and here goes the question: is there a way to make these four in one
> so strictly one random question is selected from all of the four
> categories?
> Thanks!
select * from (select * from CandidateQuestions order by rand() ) t group by
Category;
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
Simcha Younger <simcha@syounger.com>