This week's post will be a relatively straightforward and revolves around MySQL and a situation that I encountered recently. Let's say that I have a database →

I recently encountered a situation where I needed to replace part of a string value for all of the records in a particular column. This is →

Say you had a table called books with data such as: +----+----------------------------+-----------+ | pk | title | author_id | +----+----------------------------+-----------+ | 1 | The Lost Symbol | 1 →