Login
Проверить формат varchar. my SQL
1287 просмотров
Перейти к просмотру всей ветки
in Antwort miltorg 18.06.21 16:59
Эта сволочь не работает как надо((((((((
{}
x{n} and x{m,n} This notation is used to match many instances of the x. In the case of x{n} the match must be exactly that many times. In the case of x{m,n}, the match can occur from m to n times. For example, to match zero or one instance of the string ari (which is identical to (ari)?), the following can be used:
SELECT 'Maria' REGEXP '(ari){0,1}';
+-----------------------------+
| 'Maria' REGEXP '(ari){0,1}' |
+-----------------------------+
| 1 |
+-----------------------------+