backendgym backendgym · reps Sign in with GitHubSign in

07Clean station names

sql-designing-and-writing / reps/07/README.md

Find the station names that end in whitespace, fix them in a transaction, and return each name before and after. Find the bad row with a pattern and correct it with a string function. Roll back at the end.

Expected: 1 changed row, Harvard to Harvard. Before the update, searching for Harvard with = finds nothing.

After the rep
  1. 1 Would your pattern also catch a name that ends in a tab? Try it inside the transaction.