2 years ago

Have you ever tried running a search in a nested JSON column inside a database with laravel where() method and it didn't work the way you expected it to due to case sensitivity(Example . https://res.cloudinary.com/practicaldev/image/fetch/s--IiaxFGf0--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/696hcw98y8kdxmv6v5lv.png But Same query works when the case match(Example Example 2 https://res.cloudinary.com/practicaldev/image/fetch/s--9wQJq0WU--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/t1tvja5x3lgwjd0rnh8p.png To overcome this challenge I came up with this modification which allowed searching with whatever case return matching results(Example 3 and 4).

Please Let me know if there are better ways to achieve this.