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. Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.