Re: MySQL "DISTINCT" query

select distinct * from mytable is functioning just as it should what the answer is not group by try pleas to explain better what do you want almir "Jared Howard" <webbie@deanox.com> schrieb im Newsbeitrag news:3.0.6.32.20010321110448.00a64b40@server.deanox.com... > I need to retrive all column information from a DISTINCT query. But so > far, I only can get one column to show by using this: > > SELECT DISTINCT my_column FROM my_table; > > which then gives me a list of my_column information and is correct, but I > need all information from all columns. Querying this: > > SELECT DISTINCT my_column, my_column2, my_column3, my_column4 FROM my_table; > > was my guess at it, but doesn't work how I'd like. > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >