Laravel’s official documentation about many to many sync states the following on syncing a third table value. How do you actually get those values however?
Normally, for case insensitive where queries, you can use the ‘ILIKE’ operator. But if you’re linking a prepopulated dataset, there’s a chance where a foreign key string doesn’t quite match another table’s key. There’s not too much info on getting case insensitive relationships working other than digging into the database dictionary and building your own … Read more