Mysql replace regex

Mysql regex replace

REGEXP_REPLACE(expression, pattern, replacement[, position[, occurrence[, match_type]]])

Example 1 - remove all "-" characters
SELECT REGEXP_REPLACE( fieldname, '-', '' ) AS newfieldname FROM tablename

Source: database.guide

Mysql regexp match word

SELECT *
FROM table 
WHERE keywords REGEXP '[[:<:]]rid[[:>:]]'

Source: stackoverflow.com

Mysql regexp replace

WITH t AS (SELECT 'aaa <b>bbb</b> ccc' AS teststring FROM dual)

SELECT
  teststring,
  regexp_replace(teststring, '<.+>') AS reg1,
  regexp_replace(teststring, '<.*>') AS reg2,
  regexp_replace(teststring, '<.*?>') AS reg3
FROM t


TESTSTRING             REG1        REG2          REG3
aaa <b>bbb</b> ccc     aaa ccc     aaa ccc       aaa bbb ccc

Source: stackoverflow.com

Mysql replace regex

DELIMITER $$

CREATE FUNCTION  `regex_replace`(pattern VARCHAR(1000),replacement VARCHAR(1000),original VARCHAR(1000))
RETURNS VARCHAR(1000)
DETERMINISTIC
BEGIN 
 DECLARE temp VARCHAR(1000); 
 DECLARE ch VARCHAR(1); 
 DECLARE i INT;
 SET i = 1;
 SET temp = '';
 IF original REGEXP pattern THEN 
  loop_label: LOOP 
   IF i>CHAR_LENGTH(original) THEN
    LEAVE loop_label;  
   END IF;
   SET ch = SUBSTRING(original,i,1);
   IF NOT ch REGEXP pattern THEN
    SET temp = CONCAT(temp,ch);
   ELSE
    SET temp = CONCAT(temp,replacement);
   END IF;
   SET i=i+1;
  END LOOP;
 ELSE
  SET temp = original;
 END IF;
 RETURN temp;
END$$

DELIMITER ;

Source: stackoverflow.com

Similar codes

0 vote347 views1 answer
Helptext in sql
SQL
0 vote385 views1 answer
Oracle winter time change
SQL
1 vote377 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
0 vote287 views1 answer
Count char in java
SQL
0 vote355 views1 answer
SQL Where-Klausel
SQL
0 vote376 views1 answer
Soql queries for not contact related account records in salesforce
SQL
2 votes349 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
7 votes330 views1 answer
Minecraft forge server host
SQL
0 vote311 views1 answer
Suse start MySQL
SQL
0 vote353 views1 answer
Sqlcmd no headers
SQL