Today I wanted to check how the UPDATE statement was used in already deleted SQL patch files.

Usually I do a git log -p and then use the interactive search in less via /, but in this case there were too many hits from Python files, so I wanted to restrict my search to SQL files only.

Turns out you can pass in the file type via …

git log -p -- '*sql'

And then use the interactive search.


While I prefer the above way, in case you are only interested in grep-style results, you can also perform a …

git grep "UPDATE" -- '*sql'