Hey, my book is finally available. Find it here.  Eloquent Beyond The Basics!
Cosme Escobedo
🔥 Tips Articles Contact

🔥 Laravel Tip: JSON Where Clauses

Mar 31, 2022

Laravel offers helpers to query JSON columns for databases that support them.

Currently, MySQL 5.7+, PostgreSQL, SQL Server 2016, and SQLite 3.9.0 (using the JSON1 extension)
tip-image-0

Other tips:

🔥 Laravel Tip: use scopes to make your code more readable Apr 21, 2022
🔥 Laravel tip: you can pass an array to the where method Feb 20, 2022
🔥 Laravel tip: blade is useful for other things besides HTML Jan 30, 2022