Module expr_fn

Functions

• char_length
  the number of characters in the string
• character_length
  the number of characters in the string
• find_in_set
  Returns a value in the range of 1 to N if the string str is in the string list strlist consisting of N substrings
• instr
  finds the position from where the substring matches the string
• left
  returns the first n characters in the string
• length
  the number of characters in the string
• lpad
  fill up a string to the length by prepending the characters
• position
  finds the position from where the substring matches the string
• reverse
  reverses the string
• right
  returns the last n characters in the string
• rpad
  fill up a string to the length by appending the characters
• strpos
  finds the position from where the substring matches the string
• substr
  substring from the position to the end
• substr_index
  Returns the substring from str before count occurrences of the delimiter
• substring
  substring from the position with length characters
• translate
  replaces the characters in from with the counterpart in to