Relevance Ranking Development Tutorials, Guides & Insights

Open the migration file in database/migrations/xxxx_xx_xx_create_posts_table.php and update it as follows:

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

   class CreatePostsTable extends Migration
   {
       public function up()
       {
           Schema::create('posts', function (Blueprint $table) {
               $table->id();
               $table->string('title');
               $table->text('content');
               $table->timestamps();
               $table->fullText(['title', 'content']); // Add a full-text index
           });
       }

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