Print Page - Need correct mysql syntax for...

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

coppermine-gallery.com/forum

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