MySQL Forums
Forum List  »  PHP

Re: Query divides movie titles into different columns
Posted by: Luigi Chiabrera
Date: November 14, 2019 04:35PM

I tried this query but it returns the id instead of the titles.

select actor_id, group_concat(distinct film_id order by film_id asc separator ' ')
from film_actor
group by actor_id

Also how can I combine it with the original query?
I imagine you are abusing your patience, but please don't
I am very familiar with mysql

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.