Postgresql with Laravel:使用子字符串过滤Json字段

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateExampleTable extends Migration
{
    public function up()
    {
        Schema::create('examples', function (Blueprint $table) {
            $table->id();
            $table->jsonb('data');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('examples');
    }
}

use Illuminate\Database\Eloquent\Model;

class Example extends Model
{
    public function scopeFilterBySubstring($query, $substring)
    {
        return $query->where('data', 'like', '%' . $substring . '%');
    }
}

$examples = Example::filterBySubstring('example')->get();