Merge rows as one field

Posted by on October 12, 2011 Leave a comment (2) Go to comments 
GROUP_CONCAT(fieldname ORDER BY fieldname ASC SEPARATOR ',')

Full code usage example:

SELECT email, studentname,
GROUP_CONCAT(matrixno ORDER BY matrixno ASC SEPARATOR ',') AS matno,
COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )

Code above used to find duplicates for email.

Facebook Twitter Email
MySQL, Programming
  1. Latoya October 24, 2011 at 3:04 pm

    Superb information here, ol’e chap; keep burning the mdigniht oil.

    Reply
  2. google backlink October 25, 2011 at 4:45 am

    hey there zulfadli.net owner found your blog via yahoo but it was hard to find and I see you could have more visitors because there are not so many comments yet. I have found site which offer to dramtically increase traffic to your blog http://xrumerservice.org they claim they managed to get close to 1000 visitors/day using their services you could also get lot more targeted traffic from search engines as you have now. I used their services and got significantly more visitors to my website. Hope this helps :) They offer backlinks seo expert backlink service backlink service Take care. John

    Reply

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>