lundi 21 décembre 2015

find_in_set within left join in Laravel

I have to join two tables with comma seperated values but how can i write it in Laravel 5.1. The raw query is as follows

SELECT * FROM table1 as t1 LEFT JOIN table2 as t2 ON find_in_set(t2.country, t1.fk_country_id);



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire