Search code examples
phpmysqllaravelfull-text-indexinglaravel-query-builder

Using query builder for adding fulltext index in Laravel


This is the query for adding fulltext index in MySQL:

ALTER TABLE `TableName`
ADD FULLTEXT INDEX `IndexName` (`ColumnName`);

But How can I use Laravel query builder to add fulltext index?


Solution

  • This should do it: DB::statement

    DB::statement('ALTER TABLE TableName ADD FULLTEXT INDEX IndexName (ColumnName)');