prorm API Reference
    Preparing search index...

    Function substring

    • Helper to create substring/contains condition Creates a LIKE '%value%' pattern

      Parameters

      • column: string
      • value: any

      Returns Record<string, any>

      // Find users whose name contains 'john'
      User.findAll({ where: substring('name', 'john') })
      // SQL: WHERE name LIKE '%john%'