forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: disturbed1 on October 28, 2007, 02:28:27 am

Title: Need correct mysql syntax for...
Post by: disturbed1 on October 28, 2007, 02:28:27 am

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

Title: Re: Need correct mysql syntax for...
Post by: Sami on October 28, 2007, 06:25:32 am

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

Code: [Select]

SELECT CONCAT(user_name,'|',user_email) as UserEmail FROM `xxx_users`;
replace xxx with your table prefix