Year of the Dragon: Through May 28th, claim free Expansion Pack (excluding Vecna Unleashed) or a Greater Elixir of Discovery! Speak to Xatheral in the Hall of Heroes. edit
Game mechanics • Newbie guide • In development • DDO Store • Social Media
Challenges • Classes • Collectables • Crafting • Enhancements • Epic Destinies • Favor • Feats
Glossary • Items • Maps • Monsters • Places • Quests • Races • Reincarnation • Skills • Spells
Please create an account or log in to remove ads, build a reputation, and unlock more editing privileges and then visit DDO wiki's IRC Chat/Discord if you need any help!
Template:Regexp encode
Usage[edit]
This template replaces special characters used in MySQL regular expressions with their encoding. See https://dev.mysql.com/doc/refman/5.5/en/regexp.html
Note: If you are trying to match a wiki page with a regular expression, remember that spaces are underscores ( _ ) in the wiki database and thus need to be replaced in the expression. For example, Regexp encode
should become Regexp_encode
.
Characters replaced:
- [
- ]
- .
- ^
- $
- *
- ?
- {
- }
- +
Characters not replaced:
- |
- ¦
- &
Note that replacing all the characters one by one is expensive. Use only when necessary. (This could be less expensive with https://www.mediawiki.org/wiki/Extension:ReplaceSet )