Find and replace across an entire Mysql database
Having to search through a database table and replace urls, content etc is something I have to do every week or two. I normally use the 'replace' command in SQL. Sometimes it is nice to check across an entire database and that requires a hefty SQL statement.
Since I've started using Mysql Workbench to manage my server databases via SSH I can now use a cool feature called 'Search table data', all you need to do is shift select the tables you wish to search in the sidebar, right click and select 'Search table data' and you are away.
:: Created: 23rd Jan '15