string-functions

Satrlar bilan ishlash (SQLite):

SELECT LENGTH(name) FROM students;                  -- uzunlik
SELECT UPPER(name), LOWER(name) FROM students;      -- katta / kichik harf
SELECT SUBSTR(name, 1, 3) FROM students;            -- 1-belgidan 3 ta
SELECT first_name || ' ' || last_name AS full_name FROM students;   -- birlashtirish
SELECT TRIM(name) FROM students;                    -- chetdagi bo‘sh joylar
SELECT REPLACE(phone, '-', '') FROM customers;
SELECT INSTR(email, '@') FROM customers;            -- belgining o‘rni

SUBSTR da sanash 1 dan boshlanadi. Domen: SUBSTR(email, INSTR(email, '@') + 1).