PHPackages                             bkstar123/mysql-search - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. bkstar123/mysql-search

ActiveLibrary[Database & ORM](/categories/database)

bkstar123/mysql-search
======================

Enable full-text search and wildcard search for laravel/mysql applications

1.0.5(6y ago)216511MITPHPPHP ^7.1.3

Since Sep 22Pushed 6y ago1 watchersCompare

[ Source](https://github.com/bkstar123/mysql-search)[ Packagist](https://packagist.org/packages/bkstar123/mysql-search)[ RSS](/packages/bkstar123-mysql-search/feed)WikiDiscussions master Synced yesterday

READMEChangelogDependenciesVersions (7)Used By (1)

bkstar123/mysql-search
======================

[](#bkstar123mysql-search)

> A lightweight package to enable full-text search and partial search for laravel/mysql applications

1. Requirements
---------------

[](#1-requirements)

- PHP 7.1.3+
- Laravel 5.5+
- MySQL 5.6+

2. Installtion
--------------

[](#2-installtion)

```
composer require bkstar123/mysql-search

```

3. Usage
--------

[](#3-usage)

For example, your database has an `articles` table with `id, title, content, status, user_id, created_at, updated_at` columns.

You want to allow users to search for a term/keyword against `title, content` columns.

In order to do so, just do the following steps:
a) In `Article` model, import & use the trait `Bkstar123\MySqlSearch\Traits\MySqlSearch`
b) In `Article` model, define a public static property named as `$mysqlSearchable`, for instance:

```