Earlier I set up a development WordPress site that mirrored a live WordPress installation. To do this I dumped the entire WordPress database using mysqldump and then imported it into a new database with mysql. Among other things that needed to be changed I needed to update any links that referenced the live site’s URL with the development site’s URL. Below I provide the command to make such an update to only a matching portion of a column in row located in a MySQL database.
I had a document the other day that I needed to search through on my Windows laptop and find specific number combinations that started with a specific three digits and ended with another digit. For example I had a list of thousands of numbers and needed to find any number that matched 333xxx4 where the xxx could be any number combination. At first I wasn’t sure what application I should use on Windows but then I remembered that Notepad++ had regular expression search and replace support. Below is an example of searching for the combination I mention above along with a list of other regular expressions that can be used for matching variables in documents opened with Notepad++.