select regexp_replace(replace(cat_title, '_', ' '), '^.+([Aa]ncient... |
6 years ago |
select regexp_replace(replace(cat_title, '_', ' '), '^.+([Aa]ncient... |
6 years ago |
select regexp_replace(cat_title, '^.+([Aa]ncient_[A-Za-z0-9]+).*?$', '\\1')... |
6 years ago |
select regexp_replace(cat_title, '.+([Aa]ncient_\w+).*?', '\\1') `Category... |
6 years ago |
select regexp_replace(cat_title, '.+([Aa]ncient_\w+)(.+?)?', '\\1')... |
6 years ago |
select regexp_replace(cat_title, '.+([Aa]ncient_[\w]+)\b(.+?)?', '\\1')... |
6 years ago |
select regexp_replace(cat_title, '.+([Aa]ncient_[\B]+)\b(.+?)?', '\\1')... |
6 years ago |
select regexp_replace(cat_title, '.+([Aa]ncient_[^_]+)(.+?)?', '\\1')... |
6 years ago |
select regexp_replace(cat_title, '.+([Aa]ncient_.+?)(_.+)?', '\\1')... |
6 years ago |
select regexp_replace(cat_title, '.+([Aa]ncient_.+)(_.+)?', '\\1') `Category... |
6 years ago |
select concat('[[:Category:', replace(cat_title, '_', ' '), ']]')... |
6 years ago |
select concat('[[:Category:', replace(cat_title, '_', ' '), ']]')... |
6 years ago |