I have a table with columns
id, q_id, Question, Answer, Q_Date
I have made a query which concatenates multiple rows having same q_id.
Here is the query:
select q_id, Question, Link, Q_Date,
GROUP_CONCAT(Answer SEPARATOR 'n') as Answer
from ask
group by q_id, Question, Link, Q_Date
What I want to do is order by the id column, but when I select id column, it shows all the rows, UnConcatenated.
please help
Aucun commentaire:
Enregistrer un commentaire