minte9
SoftwareDevelopment / MYSQL





Select 

 
SELECT REPLACE(catg, "-", "_") FROM catgs;

Update 

 
UPDATE page SET title = REPLACE(title, CONCAT(catg, " ",subcatg, " "), "");






Questions and answers:
Clink on Option to Answer




1. You can use REPLACE with ...

  • a) SELECT
  • b) SELECT or UPDATE

2. Which is correct?

  • a) SELECT {{REPLACE}}(catg, "-", "_") FROM catgs;
  • b) SELECT {{REPLACE}}("-", "_", catg) FROM catgs;


References: