prorm API Reference
    Preparing search index...

    Function match

    • Helper to create MATCH condition for full-text search Database-specific: uses MATCH AGAINST in MySQL, @@ in PostgreSQL

      Parameters

      • column: string
      • pattern: string

      Returns Record<string, any>

      // Full-text search
      User.findAll({ where: match('bio', 'javascript programming') })
      // MySQL: WHERE MATCH(bio) AGAINST('javascript programming')
      // PostgreSQL: WHERE bio @@ to_tsquery('javascript')