'SQL - Replace specific char in a text

I am trying to find a way to replace any "Blabla Professional Blabla" or "Blabla Professionnel Blabla" string value on a SQL query to "Pro" while keeping the "Blabla" values. I can't figure it out. I tried SUBSTRING function already.

mysqlsql


Solution 1:[1]

Use Replace function

REPLACE('Blabla Professional Blabla','Professional','Pro')

Or

REPLACE('Blabla Professionnel Blabla','Professionnel','Pro')

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 mklement0

Related Questions