Re: [PHP-DB] MySQL: Random select with specific count of a column

2004-06-29 Thread Torsten Roehr
"Pablo M. Rivas" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello Torsten, > > This is one, but I think you can find another one: > Supose your table is called tablename > > select * from tablename as a left join tablename as b on > a.category = b.category and

Re: [PHP-DB] MySQL: Random select with specific count of a column

2004-06-29 Thread Pablo M. Rivas
Hello Torsten, This is one, but I think you can find another one: Supose your table is called tablename select * from tablename as a left join tablename as b on a.category = b.category and a.name<>b.name and a.language=b.language where a.language='de' and b.name is n