| select user_name from zhwiki_p.user where user_name regexp '做.*[猫貓]' limit 5000;
|
7 years ago |
| select user_name from jawiki_p.user where user_name regexp '蘭.*維.*一' limit... |
7 years ago |
| use jawiki_p;
select user_name from user where user_name regexp 'Lanwi' limit 5000;
|
7 years ago |
| use jawiki_p;
select user_name from user where user_name regexp '兰.*维' limit 5000;
|
7 years ago |
| use jawiki_p;
select user_name from user where user_name regexp '蘭.*維' limit 5000;
|
7 years ago |
| use zhwiki_p;
select user_name from user where user_name regexp '蘭.*唯' limit 5000;
|
7 years ago |
| use zhwiki_p;
select user_name from user where user_name regexp '兰.*唯' limit 5000;
|
7 years ago |
| use zhwiki_p;
select user_name from user where user_name regexp '兰.*维' limit 5000;
|
7 years ago |
| use zhwiki_p;
select user_name from user where user_name regexp '蘭.*維' limit 5000;
|
7 years ago |
| use zhwiki_p;
select user_name from user where user_name regexp... |
7 years ago |
| use zhwiki_p;
select '$惡魔$' regexp '[兰蘭蓝藍篮籃].*[维維唯]';
/*
select user_name... |
7 years ago |
| use zhwiki_p;
select user_name from user where user_name regexp... |
7 years ago |
| use zhwiki_p;
select user_name from user where user_name rlike... |
7 years ago |
| use zhwiki_p;
select user_name from user where user_name rlike... |
7 years ago |
| use zhwiki_p;
select user_name from user where user_name rlike... |
7 years ago |
| use zhwiki_p;
select user_name from user where user_name rlike... |
7 years ago |
| use enwiki_p;
select user_name from user where user_name rlike '林.*士.*涵' limit 5000; |
7 years ago |
| use jawiki_p;
select user_name from user where user_name rlike '林.*士.*涵' limit 5000; |
7 years ago |
| use zhwiki_p;
select user_name from user where user_name rlike '林.*士.*涵' limit 5000; |
7 years ago |
| use zhwiki_p;
select user_name from user where user_name rlike '兰.*维.*一' limit 5000; |
7 years ago |
| use zhwiki_p;
select user_name from user where user_name rlike '蘭.*維.*一' limit 5000; |
7 years ago |
| use enwiki_p;
select user_name from user where user_name rlike '蘭維一' limit 5000; |
7 years ago |
| use jawiki_p;
select user_name from user where user_name rlike '蘭維一' limit 5000; |
7 years ago |
| use zhwiki_p;
select user_name from user where user_name rlike '蘭維一' limit 5000; |
7 years ago |
