Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Need correct mysql syntax for...  (Read 2223 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.016 seconds with 20 queries.