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?
This should do it: DB::statement
DB::statement('ALTER TABLE TableName ADD FULLTEXT INDEX IndexName (ColumnName)');
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With