Please enable JavaScript.
Coggle requires JavaScript to display documents.
String Functions (SUBSTRING (SELECT SUBSTRING ('mytext', 1,7)…
String Functions
SUBSTRING
SELECT SUBSTRING ('mytext', 1,7)
-
SELECT SUBSTRING ('mytext', -3 )
Gets the 3rd last, 2nd last and last letters
SELECT SUBSTRING ('mytext', -1)
-
SELECT from column
SELECT SUBSTRING (fname, 1,5) FROM employees
REPLACE
SELECT REPLACE ('mystr', 'my', 'MY');
-
CONCAT()
SELECT CONCAT (column1, ' text', colunm2) FROM table;
CONCAT_WS
SELECT CONCAT_WS ('-', column1, column2, column3) FROM TABLE
-
-
CHAR_LENGTH
SELECT fname, CHAR_LENGTH(fname) FROM emp
-
-