Version: current

     1 <?php
     2 /**
     3  * @package sapphire
     4  * @subpackage search
     5  */
     6
     7 /**
     8  * Filters by full-text matching on the given field.
     9  *
    10  * Full-text indexes are only available with MyISAM tables. The following column types are
    11  * supported:
    12  *   - Char
    13  *   - Varchar
    14  *   - Text
    15  *
    16  * To enable full-text matching on fields, you also need to add an index to the
    17  * database table, using the {$indexes} hash in your DataObject subclass:
    18  *
    19  * <code>
    20  *   static $indexes = array(
    21  *      'SearchFields' => 'fulltext(Name, Title, Description)'
    22  *   );
    23  * </code>
    24  *
    25  * @package sapphire
    26  * @subpackage search
    27  */
    28 class FulltextFilter extends SearchFilter {
    29
    30     public function apply(SQLQuery $query) {
    31         $query->where(sprintf(
    32             "MATCH (%s) AGAINST ('%s')",
    33             $this->getDbName(),
    34             Convert::raw2sql($this->getValue())
    35         ));
    36         return $query;
    37     }
    38
    39     public function isEmpty() {
    40         return $this->getValue() == null || $this->getValue() == '';
    41     }
    42 }
    43 ?>

[Raise a SilverStripe Framework issue/bug](https://github.com/silverstripe/silverstripe-framework/issues/new)
- [Raise a SilverStripe CMS issue/bug](https://github.com/silverstripe/silverstripe-cms/issues/new)
- Please use the Silverstripe Forums to ask development related questions. -