prorm API Reference
    Preparing search index...

    Function matchFulltext

    • Create an explicit full-text search condition (alias for natural language mode) SQL: MATCH(columns) AGAINST(searchTerm IN NATURAL LANGUAGE MODE)

      Parameters

      • columns: string | string[]

      Returns { $match: { columns: string[]; mode: "natural" } }

      import { matchFulltext } from 'orm';
      Article.findAll({
      where: {
      [matchFulltext(['title', 'body'])]: 'database'
      }
      })
      // SQL: WHERE MATCH(title, body) AGAINST('database' IN NATURAL LANGUAGE MODE)