• ⌂ Query Functions
• Function Categories
  • Aggregate
  • Date & Time
  • Logical
  • Math
  • Object Information
  • Text

Text Query Functions

• CHAR_LENGTH(String) - Returns the number of characters in String, where String is any string or field, which may include UTF8 characters.
• CONCAT(String1,String2,...) - Concatenates any number of comma-separated strings and field values.
• LENGTH(Field) - Returns the number of bytes stored in Field.
• LOWER(String) - Returns String in all lowercase.
• MATCHES(Field,Keywords) - Matches a string of space-separated keywords against a field, such as Object Keywords.  This is useful for performing efficient keyword searches, which are currently implemented using MySQL's Full-Text Search Functions.
• NULLIF(Expression1,Expression2) - Returns NULL if Expression1 equals Expression2, otherwise returns Expression1.
• REVERSE(String) - Returns String with all characters in reverse order.
• SUBSTR(String,Offset[,Length]) - Returns a segment of String that starts at Offset (zero-based) and is up to Length characters long.  If Length is not specified, the entire String from the Offset will be returned.
• SUBSTRING(String,Offset[,Length]) - Returns a segment of String that starts at Offset (zero-based) and is up to Length characters long.  If Length is not specified, the entire String from the Offset will be returned.
• UPPER(String) - Returns String in all uppercase.

• < META()
• More >