before autoformat
SELECT CONCAT(LEFT(u.fio, LOCATE(" ", SUBSTRING_INDEX(u.fio," ",2))+1)) fio
after autoformat
SELECT CONCAT(
LEFT(u.fio, LOCATE(" ", SUBSTRING_INDEX(u.fio," ",2))+1)) fio
before autoformat
SELECT CONCAT(LEFT(u.fio, LOCATE(" ", SUBSTRING_INDEX(u.fio," ",2))+1)) fio
after autoformat
SELECT CONCAT(
LEFT(u.fio, LOCATE(" ", SUBSTRING_INDEX(u.fio," ",2))+1)) fio
Please login to leave a reply, or register at first.