After more fooling around, I found that this yields something ordered by the first field:
select REPLACE(eMail, '- ', '') AS Email, IFNULL(foreignKey, '') AS "Foreign Key", "Full Name", "List Membership" from PHPLIST2 AS Z WHERE eMail IS NOT NULL GROUP by REPLACE(eMail, '- ', '') Is this the only way? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
