like query

建立一個新的 Provider

<?php

    namespace App\Providers;


    use Illuminate\Database\Eloquent\Builder;
    use Illuminate\Support\ServiceProvider;

    class MacroServiceProvider extends ServiceProvider
    {
        /**
         * Boot the macro extend query for the application.
         *
         * @return void
         */
        public function boot()
        {
            Builder::macro('like', function ($column, $value) {

                $this->where($column, 'like', "%$value%");

                return $this;
            });
        }
    }

-------
去 config 設定檔註冊新建的 Provider
'provider' =>[
...
\App\Providers\MacroServiceProvider::class
]

-------
然後就可以用 $query->like($column,$value);