Need correct mysql syntax for...

[disturbed1]

Can someone please show me what would be the correct syntax to get phpmyadmin to list 1 per line the name and email address of the Coppermine user database with a | as a delimiter?

Thanks

[Sami]

This is not a mysql support forum !
BTW here is your answer

Code Select Expand


SELECT CONCAT(user_name,'|',user_email) as UserEmail FROM `xxx_users`;

replace xxx with your table prefix