Full-Text Search in Laravel

Full-Text in Laravel

Laravel supports full-text search via whereFullText() in Eloquent queries and fullText() in migrations.

Example

// Migration
$table->fullText(['title', 'body']);

// Eloquent query
Article::whereFullText(['title', 'body'], 'mysql performance')->get();

// With options
Article::whereFullText(['title', 'body'], '+mysql -oracle', [
    'mode' => 'boolean',
])->get();

PHP

Full Editor

Pro Tip

Laravel's whereFullText maps directly to MATCH AGAINST under the hood.

Related Resources

MySQL Reference

Complete tag & property list

MySQL How-To Guides

Step-by-step practical guides

MySQL Exercises

Practice what you've learned