In the query SELECT REGEXP_REPLACE('an Der Mauer', '^([[:lower:]])', CONCAT('\\1', '-', UPPER('\\1')));
the result returned is 'a-an der Mauer', not 'a-An der Mauer' as I would expect. Am I doing something wrong, or is this a bug in the REGEXP-REPLACE() function?
MariaDb REGEXP_REPLACE not applying UCASE/UPPER in replacement
133 Views Asked by hellerim At
1
There are 1 best solutions below
Related Questions in UPPERCASE
- Postgres PSQL on Windows do not connect (authentication failed) for a user with uppercases
- Flutter Make Textfield input become uppercase
- How to convert uppercase/lowercase turkish letters to each other?
- Issue with 'upper-case' module in Node.js: ERR_REQUIRE_ESM when using require()
- Make all the first letters uppercase except for words with at max 3 characters
- Excel VBA advanced filter - uppercase
- Finding uppercase letters
- Need to change text to upper case in JavaScript - createJs
- Why does setting a nullable type to null result in an "Overload resolution ambiguity"?
- Failing to convert upper to lower and vice versa user input string
- X64 Assembly uppercase function
- Kotlin/TeamCity environment variable to uppercase
- problems with case sensitive when migrating php site from windows apache to linux apache
- The name of database and for each table isn't uppercase in the first letter of the word when I using JPA Hibernate
- Python-docx confuses upper and lowercase in extracted text portions
Related Questions in REGEXP-REPLACE
- Regex is working in local machine. But in the production machine, it is not working
- How to add a 1 to a phone number and remove the dashes?
- How do you handler parsing and substituting '[' and ']' characters in kdb+ strings?
- How does a RE fully match a word that should not be highlighted if there are letters or words before and after it
- Handling backreferences in re.sub when replacement includes numbers
- Azure Claim Regex - Unable to filter a claim
- Powershell regex replace : string is unchanged
- Powershell script to mask the passwords in config file
- How to use a case statement in regexp_replace function？
- RegEx syntax in tableau for replacing word starting with exact alphabets PR
- Trouble with Extract Number from a string
- How to replace special characters from a column using DUCK DB?
- How do I write responsive regular expression in Python?
- I need to treat values from a string field and break it down into an array
- How can I prevent interpretation of \u in the replace string
Related Questions in MARIADB-10.6
- Azure Wordpress MySQL performance
- mysql error message: #1452 - Cannot add or update a child row: a foreign key constraint fails
- docker not finding focal Release mariadb mac m1
- MariaDB 10.6.x Error 4150 (HY000) ER_USER_IS_BLOCKED
- Hibernate-sequence generates duplicate keys when using hibernate envers
- Changing datatypes on a MariaDB replica is failing
- How to Optimize SQL Restore Performance with MySQL Dump
- Why does this MariaDB SQL query return more values when not using a CTE?
- Maria DB Server Stopped By 'oom-kill' status=9/KILL in Ubuntu 22.04.2 LTS, If possible provide simple solution?
- Using stored procedure parameters in delete queries deletes all records
- any alternative to mysql left join copy table_B content in table_A without duplicates
- How to extract Nested Json Keys in Mariadb?
- Invalid DB type - DATETIME /* MARIADB-5.3 */
- How to get data from a LONGTEXT to perform string operations
- Cannot save emojis in utf8mb3 tables… Overnight, since MariaDB 10.6 update and switching to nd_mysqli
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
It was really too late yesterday evening! Of course, UPPER() is applied to '\\1' before \\1 is evaluated. Therefore, since each of the participating characters is its own uppercase version as well as its own lowercase version, nothing visible happens. As long as I cannot pass UPPER as a function reference I need to resolve this problem differently.