1
2
3
4
5
6
7
8
9
10
11
|
/* syntax version 1 */
SELECT
value,
Unicode::ReplaceAll(value, Utf8("аф"), Utf8("zzz")) AS all,
Unicode::ReplaceFirst(value, Utf8("а"), Utf8("z")) AS first,
Unicode::ReplaceLast(value, Utf8("а"), Utf8("z")) AS last,
Unicode::ReplaceFirst(value, Utf8("а"), Utf8("")) AS first2,
Unicode::ReplaceLast(value, Utf8("а"), Utf8("")) AS last2,
Unicode::ReplaceFirst(value, Utf8("а"), Utf8("zzz")) AS first3,
Unicode::ReplaceLast(value, Utf8("а"), Utf8("zzz")) AS last3
FROM Input
|
