Thesaurus that gathers information of functions from MySQL
type: NamedIndividual
type: conceptScheme
creator: Ana Iglesias (Universidad Politécnica de Madrid)
date: 2021-09-07
has top concept: DateTime Functions
has top concept: Numeric Functions
has top concept: String Functions
has top concept: String metrics Functions
preferred label: Functions taxonomy

ABS
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the absolute value of a number
in scheme: Thesaurus that gathers information of functions from MySQL

ACOS
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the arc cosine of a number
in scheme: Thesaurus that gathers information of functions from MySQL

ADDDATE
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Adds a time/date interval to a date and then returns the date
in scheme: Thesaurus that gathers information of functions from MySQL

ADDTIME
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Adds a time interval to a time/datetime and then returns the time/datetime
in scheme: Thesaurus that gathers information of functions from MySQL

ASCII
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the ASCII value for the specific character
in scheme: Thesaurus that gathers information of functions from MySQL

ASIN
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the arc sine of a number
in scheme: Thesaurus that gathers information of functions from MySQL

ATAN
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the arc tangent of one or two numbers
in scheme: Thesaurus that gathers information of functions from MySQL

ATAN2
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the arc tangent of two numbers
in scheme: Thesaurus that gathers information of functions from MySQL

AVG
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the average value of an expression
in scheme: Thesaurus that gathers information of functions from MySQL

BIT_LENGTH
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the number of bits in a string.
in scheme: Thesaurus that gathers information of functions from MySQL

BITAND
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: The bitwise AND operation
in scheme: Thesaurus that gathers information of functions from MySQL

BITGET
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns true if and only if the first parameter has a bit set in the position specified by the second parameter.
in scheme: Thesaurus that gathers information of functions from MySQL

BITNOT
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: The bitwise NOT operation
in scheme: Thesaurus that gathers information of functions from MySQL

BITOR
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: The bitwise OR operation
in scheme: Thesaurus that gathers information of functions from MySQL

BITXOR
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: The bitwise XOR operation
in scheme: Thesaurus that gathers information of functions from MySQL

Block distance
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

CEIL
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the smallest integer value that is >= to a number
in scheme: Thesaurus that gathers information of functions from MySQL

CEILING
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the smallest integer value that is >= to a number
in scheme: Thesaurus that gathers information of functions from MySQL

CHAR
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the character that represents the ASCII value
in scheme: Thesaurus that gathers information of functions from MySQL

CHAR_LENGTH
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the length of a string (in characters)
in scheme: Thesaurus that gathers information of functions from MySQL

CHARACTER_LENGTH
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the length of a string (in characters)
in scheme: Thesaurus that gathers information of functions from MySQL

chomp
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns s1 without s2 (it s2 is in s1, else returns s1 as it was)
in scheme: Thesaurus that gathers information of functions from MySQL

COMPRESS
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Compresses the data using the specified compression algorithm
in scheme: Thesaurus that gathers information of functions from MySQL

CONCAT
type: NamedIndividual
type: Concept
broader: String Functions
definition: Adds two or more expressions together
in scheme: Thesaurus that gathers information of functions from MySQL

CONCAT_WS
type: NamedIndividual
type: Concept
broader: String Functions
definition: Adds two or more expressions together with a separator
in scheme: Thesaurus that gathers information of functions from MySQL

Confusion probability
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

contains
type: NamedIndividual
type: Concept
broader: String Functions
definition: Checks if s2 is contained in s1 and returns a boolean
in scheme: Thesaurus that gathers information of functions from MySQL

COS
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the cosine of a number
in scheme: Thesaurus that gathers information of functions from MySQL

COSH
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Calculate the hyperbolic cosine
in scheme: Thesaurus that gathers information of functions from MySQL

COT
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the cotangent of a number
in scheme: Thesaurus that gathers information of functions from MySQL

COUNT
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the number of records returned by a select query
in scheme: Thesaurus that gathers information of functions from MySQL

CURDATE
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the current date
in scheme: Thesaurus that gathers information of functions from MySQL

CURRENT_DATE
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the current date
in scheme: Thesaurus that gathers information of functions from MySQL

CURRENT_TIME
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the current time
in scheme: Thesaurus that gathers information of functions from MySQL

CURRENT_TIMESTAMP
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the current date and time
in scheme: Thesaurus that gathers information of functions from MySQL

CURTIME
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the current time
in scheme: Thesaurus that gathers information of functions from MySQL

Damerau-Levenshtain distance
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

DATE
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Extracts the date part from a datetime expression
in scheme: Thesaurus that gathers information of functions from MySQL

DATE_ADD
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Adds a time/date interval to a date and then returns the date
in scheme: Thesaurus that gathers information of functions from MySQL

DATE_FORMAT
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Formats a date
in scheme: Thesaurus that gathers information of functions from MySQL

datePart
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns part of a date.
in scheme: Thesaurus that gathers information of functions from MySQL

DATE_SUB
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Subtracts a time/date interval from a date and then returns the date
in scheme: Thesaurus that gathers information of functions from MySQL

DATEDIFF
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the number of days between two date values
in scheme: Thesaurus that gathers information of functions from MySQL

DateTime Functions
type: NamedIndividual
type: Concept
definition: Functions applied over dates
in scheme: Thesaurus that gathers information of functions from MySQL
narrower: ADDDATE
narrower: ADDTIME
narrower: CURDATE
narrower: CURRENT_DATE
narrower: CURRENT_TIME
narrower: CURRENT_TIMESTAMP
narrower: CURTIME
narrower: DATE
narrower: DATE_ADD
narrower: DATE_FORMAT
narrower: datePart
narrower: DATE_SUB
narrower: DATEDIFF
narrower: DAY
narrower: DAYNAME
narrower: DAYOFMONTH
narrower: DAYOFWEEK
narrower: DAYOFYEAR
narrower: EXTRACT
narrower: FROM_DAYS
narrower: HOUR
narrower: inc
narrower: LAST_DAY
narrower: LOCALTIME
narrower: LOCALTIMESTAMP
narrower: MAKEDATE
narrower: Creates and returns a time based on an hour
narrower: MICROSECOND
narrower: MINUTE
narrower: MONTH
narrower: MONTHNAME
narrower: NOW
narrower: PARSEDATETIME
narrower: PERIOD_ADD
narrower: PERIOD_DIFF
narrower: QUARTER
narrower: SEC_TO_TIME
narrower: SECOND
narrower: STR_TO_DATE
narrower: SUBDATE
narrower: SUBTIME
narrower: SYSDATE
narrower: TIME
narrower: TIME_FORMAT
narrower: TIME_TO_SEC
narrower: TIMEDIFF
narrower: TIMESTAMP
narrower: toDate
narrower: TO_DAYS
narrower: WEEK
narrower: WEEKDAY
narrower: WEEKOFYEAR
narrower: YEAR
narrower: YEARWEEK

DAY
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the day of the month for a given date
in scheme: Thesaurus that gathers information of functions from MySQL

DAYNAME
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the weekday name for a given date
in scheme: Thesaurus that gathers information of functions from MySQL

DAYOFMONTH
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the day of the month for a given date
in scheme: Thesaurus that gathers information of functions from MySQL

DAYOFWEEK
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the weekday index for a given date
in scheme: Thesaurus that gathers information of functions from MySQL

DAYOFYEAR
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the day of the year for a given date
in scheme: Thesaurus that gathers information of functions from MySQL

DECRYPT
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Decrypts data using a key
in scheme: Thesaurus that gathers information of functions from MySQL

DEGREES
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Converts a value in radians to degrees
in scheme: Thesaurus that gathers information of functions from MySQL

DIFFERENCE
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the difference between the sounds of two strings
in scheme: Thesaurus that gathers information of functions from MySQL

DIV
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Used for integer division
in scheme: Thesaurus that gathers information of functions from MySQL

ENCRYPT
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Encrypts data using a key
in scheme: Thesaurus that gathers information of functions from MySQL

endsWith
type: NamedIndividual
type: Concept
broader: String Functions
definition: Checks if s1 ends with s2 and returns a boolean
in scheme: Thesaurus that gathers information of functions from MySQL

equal
type: NamedIndividual
type: Concept
broader: Logical Functions
definition: Checks if two given values are the same
in scheme: Thesaurus that gathers information of functions from MySQL

escape
type: NamedIndividual
type: Concept
broader: String Functions
definition: escape in the given escaping modes
in scheme: Thesaurus that gathers information of functions from MySQL

EXP
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns e raised to the power of a specified number
in scheme: Thesaurus that gathers information of functions from MySQL

EXPAND
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Expands data that was compressed using the COMPRESS function
in scheme: Thesaurus that gathers information of functions from MySQL

EXTRACT
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Extracts a part from a given date
in scheme: Thesaurus that gathers information of functions from MySQL

Fellegi-Sunters metric
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

FIELD
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the index position of a value in a list of values
in scheme: Thesaurus that gathers information of functions from MySQL

find
type: NamedIndividual
type: Concept
broader: String Functions
definition: Attempts to find the next subsequence of the string that matches the pattern (maintains duplicates)
in scheme: Thesaurus that gathers information of functions from MySQL

FIND_IN_SET
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the position of a string within a list of strings
in scheme: Thesaurus that gathers information of functions from MySQL

FLOOR
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the largest integer value that is <= to a number
in scheme: Thesaurus that gathers information of functions from MySQL

FORMAT
type: NamedIndividual
type: Concept
broader: String Functions
definition: Formats a number to a format like #
in scheme: Thesaurus that gathers information of functions from MySQL

FROM_DAYS
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns a date from a numeric datevalue
in scheme: Thesaurus that gathers information of functions from MySQL

Grammar-based distance
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

greater than
type: NamedIndividual
type: Concept
broader: Logical Functions
definition: Checks if numerical value is greater than another
in scheme: Thesaurus that gathers information of functions from MySQL

GREATEST
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the greatest value of the list of arguments
in scheme: Thesaurus that gathers information of functions from MySQL

Hamming distance
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

HASH
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Calculate the hash value using an algorithm
definition: and repeat this process for a number of iterations
in scheme: Thesaurus that gathers information of functions from MySQL

Hellinger distance
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

HEXTORAW
type: NamedIndividual
type: Concept
broader: String Functions
definition: Converts a hex representation of a string to a string
in scheme: Thesaurus that gathers information of functions from MySQL

HOUR
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the hour part for a given date
in scheme: Thesaurus that gathers information of functions from MySQL

inc
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns a date changed by the given amount in the given unit of time. Unit defaults to 'hour'.
in scheme: Thesaurus that gathers information of functions from MySQL

Information radius
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

INSERT
type: NamedIndividual
type: Concept
broader: String Functions
definition: Inserts a string within a string at the specified position and for a certain number of characters
in scheme: Thesaurus that gathers information of functions from MySQL

INSTR
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the position of the first occurrence of a string in another string
in scheme: Thesaurus that gathers information of functions from MySQL

Jaccard simmilarity
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

Jaro-Winkler distance
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

LAST_DAY
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Extracts the last day of the month for a given date
in scheme: Thesaurus that gathers information of functions from MySQL

lastIndexOf
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the index fo s2 last ocurring in s1 as an integer, returns -1 if s2 is not found in s1
in scheme: Thesaurus that gathers information of functions from MySQL

LCASE
type: NamedIndividual
type: Concept
broader: String Functions
definition: Converts a string to lower-case
in scheme: Thesaurus that gathers information of functions from MySQL

LEAST
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the smallest value of the list of arguments
in scheme: Thesaurus that gathers information of functions from MySQL

LEFT
type: NamedIndividual
type: Concept
broader: String Functions
definition: Extracts a number of characters from a string (starting from left)
in scheme: Thesaurus that gathers information of functions from MySQL

LENGTH
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the length of a string (in bytes)
in scheme: Thesaurus that gathers information of functions from MySQL

less than
type: NamedIndividual
type: Concept
broader: Logical Functions
definition: Checks if numerical value is less than another
in scheme: Thesaurus that gathers information of functions from MySQL

Levenshtain distance
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

LN
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the natural logarithm of a number
in scheme: Thesaurus that gathers information of functions from MySQL

LOCALTIME
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the current date and time
in scheme: Thesaurus that gathers information of functions from MySQL

LOCALTIMESTAMP
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the current date and time
in scheme: Thesaurus that gathers information of functions from MySQL

LOCATE
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the position of the first occurrence of a substring in a string
in scheme: Thesaurus that gathers information of functions from MySQL

LOG
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the natural logarithm of a number
definition: or the logarithm of a number to a specified base
in scheme: Thesaurus that gathers information of functions from MySQL

LOG10
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the natural logarithm of a number to base 10
in scheme: Thesaurus that gathers information of functions from MySQL

LOG2
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the natural logarithm of a number to base 2
in scheme: Thesaurus that gathers information of functions from MySQL

Logical Functions
type: NamedIndividual
type: Concept
definition: Logical operators
in scheme: Thesaurus that gathers information of functions from MySQL
narrower: equal
narrower: greater than
narrower: less than

LPAD
type: NamedIndividual
type: Concept
broader: String Functions
definition: Left-pads a string with another string
definition: to a certain length
in scheme: Thesaurus that gathers information of functions from MySQL

LSHIFT
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: The bitwise left shift operation
in scheme: Thesaurus that gathers information of functions from MySQL

LTRIM
type: NamedIndividual
type: Concept
broader: String Functions
definition: Removes leading spaces from a string
in scheme: Thesaurus that gathers information of functions from MySQL

MAKEDATE
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Creates and returns a date based on a year and a number of days value
in scheme: Thesaurus that gathers information of functions from MySQL

Creates and returns a time based on an hour
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: and second value
definition: minute
in scheme: Thesaurus that gathers information of functions from MySQL

match
type: NamedIndividual
type: Concept
broader: String Functions
definition: Attempts to match the string in its entirety against the regex pattern and returns an array of capture groups (removes duplicates) - returning the first match
in scheme: Thesaurus that gathers information of functions from MySQL

MAX
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the maximum value in a set of values
in scheme: Thesaurus that gathers information of functions from MySQL

Maximal Matches
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

md5
type: NamedIndividual
type: Concept
broader: String Functions
definition: return hash in md-5
in scheme: Thesaurus that gathers information of functions from MySQL

MICROSECOND
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the microsecond part of a time/datetime
in scheme: Thesaurus that gathers information of functions from MySQL

MID
type: NamedIndividual
type: Concept
broader: String Functions
definition: Extracts a substring from a string (starting at any position)
in scheme: Thesaurus that gathers information of functions from MySQL

MIN
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the minimum value in a set of values
in scheme: Thesaurus that gathers information of functions from MySQL

MINUTE
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the minute part of a time/datetime
in scheme: Thesaurus that gathers information of functions from MySQL

MOD
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the remainder of a number divided by another number
in scheme: Thesaurus that gathers information of functions from MySQL

MONTH
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the month part for a given date
in scheme: Thesaurus that gathers information of functions from MySQL

MONTHNAME
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the name of the month for a given date
in scheme: Thesaurus that gathers information of functions from MySQL

NOW
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the current date and time
in scheme: Thesaurus that gathers information of functions from MySQL

Numeric Functions
type: NamedIndividual
type: Concept
definition: Functions applied over numbers
in scheme: Thesaurus that gathers information of functions from MySQL
narrower: ABS
narrower: ACOS
narrower: ASIN
narrower: ATAN
narrower: ATAN2
narrower: AVG
narrower: BITAND
narrower: BITGET
narrower: BITNOT
narrower: BITOR
narrower: BITXOR
narrower: CEIL
narrower: CEILING
narrower: COMPRESS
narrower: COS
narrower: COSH
narrower: COT
narrower: COUNT
narrower: DECRYPT
narrower: DEGREES
narrower: DIV
narrower: ENCRYPT
narrower: EXP
narrower: EXPAND
narrower: FLOOR
narrower: GREATEST
narrower: HASH
narrower: LEAST
narrower: LN
narrower: LOG
narrower: LOG10
narrower: LOG2
narrower: LSHIFT
narrower: MAX
narrower: MIN
narrower: MOD
narrower: ORA_HASH
narrower: PI
narrower: POW
narrower: POWER
narrower: RADIANS
narrower: RAND
narrower: RAND_UUID
narrower: ROUND
narrower: ROUNDMAGIC
narrower: RSHIFT
narrower: SECURE_RAND
narrower: SIGN
narrower: SIN
narrower: SINH
narrower: SQRT
narrower: SUM
narrower: TAN
narrower: TANH
narrower: TRUNCATE
narrower: ZERO

OCTET_LENGTH
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the number of bytes in a string
in scheme: Thesaurus that gathers information of functions from MySQL

ORA_HASH
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Computes a hash value
in scheme: Thesaurus that gathers information of functions from MySQL

Overlap coefficient
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

PARSEDATETIME
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Parses a string and returns a timestamp
in scheme: Thesaurus that gathers information of functions from MySQL

b ] where a is the substring within string before the first occurrence of frag in string
type: NamedIndividual
type: Concept
broader: String Functions
definition: and b is the substring after frag. If boolean is true
definition: frag is not returned
in scheme: Thesaurus that gathers information of functions from MySQL
preferred label: frag

PERIOD_ADD
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Adds a specified number of months to a period
in scheme: Thesaurus that gathers information of functions from MySQL

PERIOD_DIFF
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the difference between two periods
in scheme: Thesaurus that gathers information of functions from MySQL

PI
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the value of PI
in scheme: Thesaurus that gathers information of functions from MySQL

POSITION
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the position of the first occurrence of a substring in a string
in scheme: Thesaurus that gathers information of functions from MySQL

POW
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the value of a number raised to the power of another number
in scheme: Thesaurus that gathers information of functions from MySQL

POWER
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the value of a number raised to the power of another number
in scheme: Thesaurus that gathers information of functions from MySQL

QUARTER
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the quarter of the year for a given date value
in scheme: Thesaurus that gathers information of functions from MySQL

QUOTE_IDENT
type: NamedIndividual
type: Concept
broader: String Functions
definition: Quotes the specified identifier. Identifier is surrounded by double quotes
in scheme: Thesaurus that gathers information of functions from MySQL

RADIANS
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Converts a degree value into radians
in scheme: Thesaurus that gathers information of functions from MySQL

RAND
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns a random number
in scheme: Thesaurus that gathers information of functions from MySQL

RAND_UUID
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns a new UUID with 122 pseudo random bits
in scheme: Thesaurus that gathers information of functions from MySQL

RAWTOHEX
type: NamedIndividual
type: Concept
broader: String Functions
definition: Converts a string or bytes to the hex representation
in scheme: Thesaurus that gathers information of functions from MySQL

REGEXP_LIKE
type: NamedIndividual
type: Concept
broader: String Functions
definition: Matches string to a regular expression
in scheme: Thesaurus that gathers information of functions from MySQL

REGEXP_REPLACE
type: NamedIndividual
type: Concept
broader: String Functions
definition: Replaces each substring that matches a regular expression
in scheme: Thesaurus that gathers information of functions from MySQL

REPEAT
type: NamedIndividual
type: Concept
broader: String Functions
definition: Repeats a string as many times as specified
in scheme: Thesaurus that gathers information of functions from MySQL

REPLACE
type: NamedIndividual
type: Concept
broader: String Functions
definition: Replaces all occurrences of a substring within a string
definition: with a new substring
in scheme: Thesaurus that gathers information of functions from MySQL

replaceChars
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the string obtained by replacing any character in s1 that is also in s2 with the character s3
in scheme: Thesaurus that gathers information of functions from MySQL

REVERSE
type: NamedIndividual
type: Concept
broader: String Functions
definition: Reverses a string and returns the result
in scheme: Thesaurus that gathers information of functions from MySQL

RFIDF distance
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

RIGHT
type: NamedIndividual
type: Concept
broader: String Functions
definition: Extracts a number of characters from a string (starting from right)
in scheme: Thesaurus that gathers information of functions from MySQL

ROUND
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Rounds a number to a specified number of decimal places
in scheme: Thesaurus that gathers information of functions from MySQL

ROUNDMAGIC
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: This function rounds numbers in a good way
definition: but it is slow
in scheme: Thesaurus that gathers information of functions from MySQL

RPAD
type: NamedIndividual
type: Concept
broader: String Functions
definition: Right-pads a string with another string
definition: to a certain length
in scheme: Thesaurus that gathers information of functions from MySQL

b ] where a is the substring within string before the last occurrence of frag in string
type: NamedIndividual
type: Concept
broader: String Functions
definition: and b is the substring after frag. If boolean is true
definition: frag is not returned
in scheme: Thesaurus that gathers information of functions from MySQL
preferred label: frag

RSHIFT
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: The bitwise right shift operation
in scheme: Thesaurus that gathers information of functions from MySQL

RTRIM
type: NamedIndividual
type: Concept
broader: String Functions
definition: Removes trailing spaces from a string
in scheme: Thesaurus that gathers information of functions from MySQL

SEC_TO_TIME
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns a time value based on the specified seconds
in scheme: Thesaurus that gathers information of functions from MySQL

SECOND
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the seconds part of a time/datetime
in scheme: Thesaurus that gathers information of functions from MySQL

SECURE_RAND
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Generates a number of cryptographically secure random numbers
in scheme: Thesaurus that gathers information of functions from MySQL

sha1
type: NamedIndividual
type: Concept
broader: String Functions
definition: return hash in sha-1
in scheme: Thesaurus that gathers information of functions from MySQL

SIGN
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the sign of a number
in scheme: Thesaurus that gathers information of functions from MySQL

Simple Matching coefficient
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

SIN
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the sine of a number
in scheme: Thesaurus that gathers information of functions from MySQL

SINH
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Calculate the hyperbolic sine
in scheme: Thesaurus that gathers information of functions from MySQL

Skew divergence
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

Sorensen-Dice coefficient
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

SOUNDEX
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns a four character code representing the sound of a string
in scheme: Thesaurus that gathers information of functions from MySQL

SPACE
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns a string of the specified number of space characters
in scheme: Thesaurus that gathers information of functions from MySQL

split
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the array of strings obtained by splitting the string at wherever separator is found in it.
in scheme: Thesaurus that gathers information of functions from MySQL

splitByCharType
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns an array of strings obtained by splitting s into groups of consecutive characters where the characters within each group share the same unicode type
in scheme: Thesaurus that gathers information of functions from MySQL

splitByLengths
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the array of strings obtained by splitting s into substrings with the given lengths.
in scheme: Thesaurus that gathers information of functions from MySQL

SQRT
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the square root of a number
in scheme: Thesaurus that gathers information of functions from MySQL

startsWith
type: NamedIndividual
type: Concept
broader: String Functions
definition: Checks if s1 starts with s2 and returns a boolean
in scheme: Thesaurus that gathers information of functions from MySQL

STR_TO_DATE
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns a date based on a string and a format
in scheme: Thesaurus that gathers information of functions from MySQL

STRCMP
type: NamedIndividual
type: Concept
broader: String Functions
definition: Compares two strings
in scheme: Thesaurus that gathers information of functions from MySQL

String Functions
type: NamedIndividual
type: Concept
definition: Functions applied over strings
in scheme: Thesaurus that gathers information of functions from MySQL
narrower: ASCII
narrower: BIT_LENGTH
narrower: CHAR
narrower: CHAR_LENGTH
narrower: CHARACTER_LENGTH
narrower: chomp
narrower: CONCAT
narrower: CONCAT_WS
narrower: contains
narrower: DIFFERENCE
narrower: endsWith
narrower: escape
narrower: FIELD
narrower: find
narrower: FIND_IN_SET
narrower: FORMAT
narrower: HEXTORAW
narrower: INSERT
narrower: INSTR
narrower: lastIndexOf
narrower: LCASE
narrower: LEFT
narrower: LENGTH
narrower: LOCATE
narrower: LPAD
narrower: LTRIM
narrower: match
narrower: md5
narrower: MID
narrower: OCTET_LENGTH
narrower: b ] where a is the substring within string before the first occurrence of frag in string
narrower: POSITION
narrower: QUOTE_IDENT
narrower: RAWTOHEX
narrower: REGEXP_LIKE
narrower: REGEXP_REPLACE
narrower: REPEAT
narrower: REPLACE
narrower: replaceChars
narrower: REVERSE
narrower: RIGHT
narrower: RPAD
narrower: b ] where a is the substring within string before the last occurrence of frag in string
narrower: RTRIM
narrower: sha1
narrower: SOUNDEX
narrower: SPACE
narrower: split
narrower: splitByCharType
narrower: splitByLengths
narrower: startsWith
narrower: STRCMP
narrower: STRINGDECODE
narrower: STRINGENCODE
narrower: STRINGTOUTF8
narrower: SUBSTRING
narrower: SUBSTRING_INDEX
narrower: Oracle-compatible TO_CHAR function that can format a timestamp
narrower: toNumber
narrower: toString
narrower: toTitleCase
narrower: TRANSLATE
narrower: TRIM
narrower: UCASE
narrower: unescape
narrower: UTF8TOSTRING
narrower: XMLATTR
narrower: XMLCDATA
narrower: XMLCOMMENT
narrower: XMLNODE
narrower: XMLSTARTDOC
narrower: XMLTEXT

String metrics Functions
type: NamedIndividual
type: Concept
definition: Functions that measure distance between two strings
in scheme: Thesaurus that gathers information of functions from MySQL
narrower: Block distance
narrower: Confusion probability
narrower: Damerau-Levenshtain distance
narrower: Fellegi-Sunters metric
narrower: Grammar-based distance
narrower: Hamming distance
narrower: Hellinger distance
narrower: Information radius
narrower: Jaccard simmilarity
narrower: Jaro-Winkler distance
narrower: Levenshtain distance
narrower: Maximal Matches
narrower: Overlap coefficient
narrower: RFIDF distance
narrower: Simple Matching coefficient
narrower: Skew divergence
narrower: Sorensen-Dice coefficient
narrower: Tau metric
narrower: Tversky index
narrower: Variational distance

STRINGDECODE
type: NamedIndividual
type: Concept
broader: String Functions
definition: Converts a encoded string using the Java string literal encoding format
in scheme: Thesaurus that gathers information of functions from MySQL

STRINGENCODE
type: NamedIndividual
type: Concept
broader: String Functions
definition: Encodes special characters in a string using the Java string literal encoding format
in scheme: Thesaurus that gathers information of functions from MySQL

STRINGTOUTF8
type: NamedIndividual
type: Concept
broader: String Functions
definition: Encodes a string to a byte array using the UTF8 encoding format
in scheme: Thesaurus that gathers information of functions from MySQL

SUBDATE
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Subtracts a time/date interval from a date and then returns the date
in scheme: Thesaurus that gathers information of functions from MySQL

SUBSTRING
type: NamedIndividual
type: Concept
broader: String Functions
definition: Extracts a substring from a string (starting at any position)
in scheme: Thesaurus that gathers information of functions from MySQL

SUBSTRING_INDEX
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns a substring of a string before a specified number of delimiter occurs
in scheme: Thesaurus that gathers information of functions from MySQL

SUBTIME
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Subtracts a time interval from a datetime and then returns the time/datetime
in scheme: Thesaurus that gathers information of functions from MySQL

SUM
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Calculates the sum of a set of values
in scheme: Thesaurus that gathers information of functions from MySQL

SYSDATE
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the current date and time
in scheme: Thesaurus that gathers information of functions from MySQL

TAN
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the tangent of a number
in scheme: Thesaurus that gathers information of functions from MySQL

TANH
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Calculate the hyperbolic tangent
in scheme: Thesaurus that gathers information of functions from MySQL

Tau metric
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

TIME
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Extracts the time part from a given time/datetime
in scheme: Thesaurus that gathers information of functions from MySQL

TIME_FORMAT
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Formats a time by a specified format
in scheme: Thesaurus that gathers information of functions from MySQL

TIME_TO_SEC
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Converts a time value into seconds
in scheme: Thesaurus that gathers information of functions from MySQL

TIMEDIFF
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the difference between two time/datetime expressions
in scheme: Thesaurus that gathers information of functions from MySQL

TIMESTAMP
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns a datetime value based on a date or datetime value
in scheme: Thesaurus that gathers information of functions from MySQL

Oracle-compatible TO_CHAR function that can format a timestamp
type: NamedIndividual
type: Concept
broader: String Functions
definition: a number
definition: or text
in scheme: Thesaurus that gathers information of functions from MySQL

toDate
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the value converted in date. Month_first false if date is formatted with the day before the month. FormatN formats of the input (don't understand this very well)
in scheme: Thesaurus that gathers information of functions from MySQL

TO_DAYS
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the number of days between a date and date 0000-00-00''
in scheme: Thesaurus that gathers information of functions from MySQL

toNumber
type: NamedIndividual
type: Concept
broader: String Functions
definition: Converts input to number
in scheme: Thesaurus that gathers information of functions from MySQL

toString
type: NamedIndividual
type: Concept
broader: String Functions
definition: Transform any data type into a string
in scheme: Thesaurus that gathers information of functions from MySQL

toTitleCase
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the string converted to titlecase (first letter of each word in uppercase)
in scheme: Thesaurus that gathers information of functions from MySQL

TRANSLATE
type: NamedIndividual
type: Concept
broader: String Functions
definition: Oracle-compatible TRANSLATE function that replaces a sequence of characters in a string with another set of characters
in scheme: Thesaurus that gathers information of functions from MySQL

TRIM
type: NamedIndividual
type: Concept
broader: String Functions
definition: Removes leading and trailing spaces from a string
in scheme: Thesaurus that gathers information of functions from MySQL

TRUNCATE
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Truncates a number to the specified number of decimal places
in scheme: Thesaurus that gathers information of functions from MySQL

Tversky index
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

UCASE
type: NamedIndividual
type: Concept
broader: String Functions
definition: Converts a string to upper-case
in scheme: Thesaurus that gathers information of functions from MySQL

unescape
type: NamedIndividual
type: Concept
broader: String Functions
definition: unescape in the given escaping modes
in scheme: Thesaurus that gathers information of functions from MySQL

UTF8TOSTRING
type: NamedIndividual
type: Concept
broader: String Functions
definition: Decodes a byte array in the UTF8 format to a string
in scheme: Thesaurus that gathers information of functions from MySQL

Variational distance
type: NamedIndividual
type: Concept
broader: String metrics Functions
in scheme: Thesaurus that gathers information of functions from MySQL

WEEK
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the week number for a given date
in scheme: Thesaurus that gathers information of functions from MySQL

WEEKDAY
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the weekday number for a given date
in scheme: Thesaurus that gathers information of functions from MySQL

WEEKOFYEAR
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the week number for a given date
in scheme: Thesaurus that gathers information of functions from MySQL

XMLATTR
type: NamedIndividual
type: Concept
broader: String Functions
definition: Creates an XML attribute element of the form name=value
in scheme: Thesaurus that gathers information of functions from MySQL

XMLCDATA
type: NamedIndividual
type: Concept
broader: String Functions
definition: Creates an XML CDATA element
in scheme: Thesaurus that gathers information of functions from MySQL

XMLCOMMENT
type: NamedIndividual
type: Concept
broader: String Functions
definition: Creates an XML comment
in scheme: Thesaurus that gathers information of functions from MySQL

XMLNODE
type: NamedIndividual
type: Concept
broader: String Functions
definition: Create an XML node element
in scheme: Thesaurus that gathers information of functions from MySQL

XMLSTARTDOC
type: NamedIndividual
type: Concept
broader: String Functions
definition: Returns the XML declaration
in scheme: Thesaurus that gathers information of functions from MySQL

XMLTEXT
type: NamedIndividual
type: Concept
broader: String Functions
definition: Creates an XML text element
in scheme: Thesaurus that gathers information of functions from MySQL

YEAR
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the year part for a given date
in scheme: Thesaurus that gathers information of functions from MySQL

YEARWEEK
type: NamedIndividual
type: Concept
broader: DateTime Functions
definition: Returns the year and week number for a given date
in scheme: Thesaurus that gathers information of functions from MySQL

ZERO
type: NamedIndividual
type: Concept
broader: Numeric Functions
definition: Returns the value 0
in scheme: Thesaurus that gathers information of functions from MySQL