1
I don’t know if anyone can help me I needed to execute this SQL
in Laravel I just don’t know how to use the GROUP_CONCAT
with the CONCAT
within?
select dictionaries.name,
GROUP_CONCAT(CONCAT('{name:"', dictionary_files.name, '", file:"',dictionary_files.path,'"}')) as files
from dictionaries
join dictionary_files on dictionaries.`id` = dictionary_files.`dictionary_id`
Where dictionary_files.name Like "Teste%" Group by dictionaries.name
Thank you.