Re: Query with DISTINCT - logic?

[Ryan Lowe]

Something like this:?

mysql> SELECT * FROM `t` WHERE `identifier` = 12345 GROUP BY `address`\G
*************************** 1. row ***************************
email: [e-mail]
address: 23 Elm Street
name: Acme Investing
street: San Diego
identifier: 12345
*************************** 2. row ***************************
email: [e-mail]
address: 90 Oak Street
name: Blarney Capital
street: Berkeley
identifier: 12345
2 rows in set (0.00 sec)