how to do substring inside query if the name are kevin_001
User::where(substr('name', 0, strpos('name', '_'), '=', 'kelvin');
Last updated
2 years ago.
you can use DB::raw method for this:
User::where(DB::raw("substr('name', 1, strpos('name', '_'))"), '=', 'kelvin');
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast