SQL 9 lekcija

String funkcijas:

SELECT CHAR(77,121,83,81,'76'); => MySQL 

SELECT  CHAR_LENGTH(CHAR(77,121,83,81,'76')); => 5 (simbolu skaits)

SELECT CONCAT('My', 'S', 'QL'); => MySQL
 
SELECT CONCAT(`ID`, `email`) FROM `users`; 
SELECT CONCAT_WS('-', `ID`, `email`) FROM `users`; 
SELECT FIELD('ej', 'Hej', 'ej', 'Heja', 'hej', 'foo'); => 2 mekle 'ej' tekstu saraksta, pozicija - index atrastai sakritībai
 
SELECT FORMAT(332.123456, 4); = > 332.1235 noapaļo 
SELECT 0x616263, HEX('abc'), UNHEX(HEX('abc')); => abc; 616263; abc; 
SELECT INSERT('Quadratic', 3, 4, 'What'); => QuWhattic 
SELECT INSTR('foobarbar', 'bar'); => 4 
SELECT LCASE('FOOOOOBAAAAR'), LOWER('BARFOOOOOOOOOO'); => fooooobaaaar barfoooooooooo
 
SELECT LEFT('foobarbar', 5); => fooba 
SELECT LENGTH('foobarbar'); => 9 (baitos)
LOAD_FILE 
SELECT LOCATE('bar', 'foobarbar'); => 4
 
SELECT LOCATE('bar', 'foobarbar',5); => 7 SELECT LPAD('hi',4,'??'); = > ??hi  (padding) 

SELECT LTRIM('  barbar'); => 'barbar'

SELECT QUOTE('Don\'t!'); => 'Don\'t!'

SELECT REPEAT('UgiBugi ', 10); => UgiBugi UgiBugi UgiBugi UgiBugi UgiBugi UgiBugi UgiBugi UgiBugi UgiBugi UgiBugi  
SELECT REPLACE('www.mysql.com', 'w', 'Ww'); => WwWwWw.mysql.com
 
SELECT REVERSE('abc'); => cba
SELECT RIGHT('foobarbar', 4); => rbar
 
SELECT RIGHT('foobarbar', 4); SELECT RPAD('hi',5,'?'); => hi??? SELECT RTRIM('barbar   ');
SELECT SPACE(6);
SELECT SUBSTRING('Quadratically',5); => ratically
 
SELECT SUBSTRING('abcdefgh', -5, 3); => def 
SELECT SUBSTRING('abcdefgh', -4); => efgh 
SELECT TRIM('  bar   '); => 'bar'
SELECT UPPER('Hej'), UCASE('Hej'); HEJ HEJ