Module org.jooq
Package org.jooq.impl

Interface QOM.SubstringIndex

All Superinterfaces:
Field<String>, FieldOrConstraint, FieldOrRow, FieldOrRowOrSelect, GroupField, Named, OrderField<String>, QueryPart, SelectField<String>, SelectFieldOrAsterisk, Serializable, TableElement, Typed<String>
Enclosing class:
QOM

public static interface QOM.SubstringIndex extends Field<String>
The SUBSTRING INDEX function.

Get a substring of a string, from the beginning until the nth occurrence of a substring.

  • Method Details

    • $string

      @NotNull @NotNull Field<String> $string()
      The string from which to get the substring.
    • $delimiter

      @NotNull @NotNull Field<String> $delimiter()
      The delimiter.
    • $n

      @NotNull @NotNull Field<? extends Number> $n()
      The number of occurrences of the delimiter.
    • $string

      @NotNull @NotNull QOM.SubstringIndex $string(Field<String> string)
      The string from which to get the substring.
    • $delimiter

      @NotNull @NotNull QOM.SubstringIndex $delimiter(Field<String> delimiter)
      The delimiter.
    • $n

      @NotNull @NotNull QOM.SubstringIndex $n(Field<? extends Number> n)
      The number of occurrences of the delimiter.