Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Need correct mysql syntax for...  (Read 1937 times)

0 Members and 1 Guest are viewing this topic.

disturbed1

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Need correct mysql syntax for...
« 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
« Last Edit: October 28, 2007, 10:41:03 am by GauGau »
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Need correct mysql syntax for...
« Reply #1 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
Logged
‍I don't answer to PM with support question
Please post your issue to related board
Pages: [1]   Go Up
 

Page created in 0.013 seconds with 20 queries.