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
- Change lowercase and uppercase of characters in java
- Python: calling upper() on words containing non-latin characters
- Input text needs a case change when button is clicked. Having trouble creating JS for this
- How to find if exist an uppercase character in string?
- VBA Code, How to change a specific word from Uppercase to Lowercase in Excel
- Convert String to Uppercase Decussate in C++
- database select result upper case first letter of name
- Add space before each Capitalized word (minus the 1st one) using Scala code
- Getting just the upper case letters from a string
- Convert all characters of a string to uppercase, except for some specific characters
- Converting Odd and Even-indexed characters in a string to uppercase/lowercase in Javascript?
- How to make recursive function, it needs to check if in a given string the current letter and the one next to it is either lowercase or upper case?
- Convert a string to ordinal upper or lower case
- Upper case a full string without using .upper function? PYTHON
- Ignoring upper case and lower case in Java
Related Questions in REGEXP-REPLACE
- Oracle multiple REPLACE options in REGEXP_REPLACE
- Oracle SQL: How do I convert the substrings in a string using to_char
- How to use regexp_replace to replace a character in a string using the select statement?
- Postgres regexp replace not working
- How to REGEXP_REPLACE special character
- Oracle declare select into update statement does not work
- SQL Oracle - Replace character in string between two vowels
- Reorder a string using REGEXP_REPLACE in a Redshift table
- Oracle regexp_replace to prevent semicolons
- Postgresql: removing spaces between certain type of digits
- using oracle regexp_replace to replace some part of a code
- RegEx Replace - Remove Non-Matched Values
- How to append something to the beginning of Regex matches?
- RegEx $0 substitution cannot manipulated (e.g. converted to upper-case)
- extract serial from string that follow fuzzy pattern SQL Netezza
Related Questions in MARIADB-10.6
- Changing datatypes on a MariaDB replica is failing
- Hibernate-sequence generates duplicate keys when using hibernate envers
- Can't Grant SLAVE MONITOR to user on MariaDB 10.6 Primary
- MariaDB concatenate 2 tables with same number of rows
- How to get only Digits from rows in mariadb?
- Migration from MySQL 5.6.35 to MariaDB 10.6.3 - Queries not working
- get first occurrence of last changed value of a column for each unique id
- Convert the SQL Server script to MariaDB script
- MySQL/Mariadb problem: `Order by DESC` before `Group by`
- Invalid DB type - DATETIME /* MARIADB-5.3 */
- Mysql GROUP BY ...but I want the oldest one
- Unescape JSON strings with JSON_TABLE in MariaDB
- Error 1064 on create trigger mysql trigger
- SQL to create a hierarchical result-set
- How to get data from a LONGTEXT to perform string operations
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 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.