MySQL Functions

Front

Not a text function: TRIM(), LEFT(), MID()

Back

TRUNCATE()

Front

Not a numeric function: MOD, SIGN, MID, POW

Back

MID

Front

Not a date function: Month, Year, Now, Pow

Back

Pow

Front

Function that returns the position of a substring in a string.

Back

INSTR

Front

Query: SELECT LENGTH("WINNER");

Back

6

Front

Query: SELECT INSTR("INDIA", "DI");

Back

3

Front

Query: SELECT concat("It", "was", "ok");

Back

"Itwasok"

Front

Query: SELECT round(153.669, 2);

Back

153.67

Front

Result of SELECT sign(26):

Back

1

Front

Query: SELECT truncate(15.79, -1), truncate(15.79, 0), truncate(15.79, 1);

Back

10 15 15.7