Match String on Multiple Columns

TL;DR: Use concatenation, Luke! I had to search a name for an user in a table containing the first and last names in separate columns. After a while I got tired on looking up the first_name and last_name columns one at a time and I decided to try and search both. The result is something […]

BAT Files: Execute Multiple Commands in a Loop

One of the tasks the other day was to load a large DB organised by year. The most efficient way was to loop through a sequence of years and execute the loader for each one. The first iteration I ended with was:

This means: For years from 1996 to 1998, with an increment of […]

Scroll to top