ORM MySQL Full-Text Search support

npm install orm-mysql-fts
3 downloads in the last week
13 downloads in the last month

ORM MySQL Full-Text Search Plugin

This plugin adds FTS support for the MySQL driver of ORM.


Of course you need orm to use it. Other than that, no more dependencies.


npm install orm-mysql-fts

DBMS Support

  • MySQL


Model.match(property1, property2, ...).against(expression [ , alias ])

alias is an alias for the MATCH (..) AGAINST (..) expression and by default is "score". By default the query will be ordered descending by this alias. Only matched rows will be returned (HAVING score > 0).


var orm = require("orm");
var fts = require("orm-mysql-fts");

orm.connect("mysql://username:password@host/database", function (err, db) {
    if (err) throw err;


    var Person = db.define("person", {
        name      : String,
        surname   : String,
        age       : Number

    Person.match("name").against("john").limit(10).run(function (err, people) {
        // .against() returns a ChainFind, you can use .limit() , .where() ..
        // (by default it orders by best match)
npm loves you