Today i had to replace some words in an sql table, but it had to be done in a case-sensitive way, so that none of my capitalized words became lowercase.
I ended up with a small SQL script like this where Paragraph and ParagraphText are my table and me column:
1 | UPDATE Paragraph |
This small script handles replaces like these:
bearbeitung
-> verarbeitung
Bearbeitung
-> Verarbeitung
If you have a better script or a more generic solution, feel free to add it in the comments below