The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
39 views

Mysql Group Concat Distinct On One Field While Returning Another

I have a group concat distinct to return a distinct set of user names (user.first_name concatenated with user.last_name with a space separator). I want the distinct to apply on the user_id and not on ...
1
vote
0answers
210 views

Duplicate GROUP_CONCAT values

Writing a plugin for Wordpress using a custom post type and an additional alias table to hold repetition of the post events. The problem comes with duplicate post meta values. wp_post_meta table: ...
1
vote
0answers
573 views

How can I join one to one to (many to one) without using group_concat

I have a table structure as follows: -- -- Table structure for table `emails` -- CREATE TABLE IF NOT EXISTS `emails` ( `ID` int(5) NOT NULL AUTO_INCREMENT, `email` varchar(255) COLLATE ...