SQL Objekti

SELECT CONV('a',16,2); => 1010 

SELECT BIN(16); => 10000 "CONV(16,10,2)" 
SELECT OCT(16); => 20 
SELECT HEX(255); => FF 
SELECT CHAR(77,121,83,81,76); => MySQL 
SELECT CONCAT(77,121,83,81,76); => 77121838176 
SELECT CONCAT_WS(',',77,121,83,81,76); => 77,121,83,81,76 
SELECT LENGTH(',///'); => 4 
SELECT LOCATE('a','1abc'); => 2 
SELECT LOCATE('a','1abcacc',3); => 5; var lietot "POSITION" un "INSTR(argumenti mainas vietam)"  
SELECT LEFT('1abcacc',3); => 1ab 
SELECT LPAD('1abcacc',10,'*'); => ***1abcacc 
SELECT RPAD('1abcacc',10,'*'); => 1abcacc*** 
SELECT SUBSTRING('1abcacc',5,3); => acc 
SELECT SUBSTRING('1abcacc1',5); => acc1 
SELECT LEFT('1abcacc1',5); =>  1abca 
TRIM ir paplašīnāts!
SELECT INSERT('1abcacc1',3,4,'****'); => 1a****c1 
SELECT REVERSE('1abcacc1'); => 1ccacba1 
SELECT LCASE('aaA'); => aaa 
SELECT LOAD_FILE('d:/roberts.txt'); => 192.168.1.103