79384471

Date: 2025-01-24 13:18:37
Score: 1.5
Natty:
Report link

I know I'm late to the game, but for future users who find this thread, this feels like a good use for TRANSLATE().

SELECT TRANSLATE(column, "AF", "BZ") FROM table

This has the benefit (or curse) of catching any variation. "Column A" becomes "Column B" for instance. It also means that "Alvin" becomes "Blvin" - which may not be intended behavior. Check your db, table, and column settings to see what consideration you need to give to case sensitivity.

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: Kevin E