SELECT CONCAT(LEFT(main.newtemp,1),SUBSTRING(main.newtemp,2,LENGTH(main.newtemp)))
     , main.newtemp
     , LEFT(main.newtemp,1)
     , SUBSTRING(main.newtemp,2,LENGTH(main.newtemp))
     , LENGTH(main.newtemp)
     , main.template_ua
FROM (
    SELECT o.template_ua, o.id, REPLACE(TRIM(o.template_ua), 'Замовлення ', '') AS newtemp
    FROM yii_doc.order_status_customer_new o
) main
WHERE CONCAT(LEFT(main.newtemp,1),SUBSTRING(main.newtemp,2,LENGTH(main.newtemp))) <> main.newtemp;


SELECT CONCAT(LEFT(main.newtemp,1),SUBSTRING(main.newtemp,2,LENGTH(main.newtemp)))
FROM (
    SELECT o.template, o.id, REPLACE(TRIM(o.template), 'Заказ ', '') AS newtemp
    FROM yii_doc.order_status_customer_new o
) main
WHERE CONCAT(LEFT(main.newtemp,1),SUBSTRING(main.newtemp,2,LENGTH(main.newtemp))) <> main.newtemp;