А Б В Г Д Е Ж З И К Л М Н О П Р С Т У Ф Х Ц Ч Ш Щ Э Ю Я
SELECT
s.id,
CONCAT(UPPER(SUBSTRING(s.name,1,1)),LOWER(SUBSTRING(s.name FROM 2))) as name,
CONCAT(UPPER(SUBSTRING(s.secondname,1,1)),LOWER(SUBSTRING(s.secondname FROM 2))) as secondname,
CONCAT(UPPER(SUBSTRING(s.surname,1,1)),LOWER(SUBSTRING(s.surname FROM 2))) as surname
FROM staff s, depstaff d, officercls o WHERE ((s.id = d.id_staff AND d.id_officercls=o.id AND o.id IN (85036001,85037001,86613001,99505462)) OR (s.id = 60918001) ) AND s.flag_hide=0 AND s.surname REGEXP '^Э'AND s.id != 457569077 GROUP BY s.id ORDER BY s.surname ASC, s.name ASC, s.secondname ASC, NUM ROWS: 0
