c_pattle Posted October 11, 2010 Share Posted October 11, 2010 I have the following query "select distinct article_author, article_author2 from articles" When I run this it returns two columns. However is there a way in which I can group these two columns into 1 column? Thanks for any help. Link to comment https://forums.phpfreaks.com/topic/215646-mysql-group-to-fields-into-1/ Share on other sites More sharing options...
Pikachu2000 Posted October 11, 2010 Share Posted October 11, 2010 SELECT CONCAT() or SELECT CONCAT_WS() clicky Or just concatenate the resultant values using PHP. Link to comment https://forums.phpfreaks.com/topic/215646-mysql-group-to-fields-into-1/#findComment-1121244 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.