searching for windows paths

[Private Citizen]

I have a VCS running against a MySQL backend (running on a Linux server). I recently migrated to new Windows 10 desktops, and decided to consolidate all of my projects in a new directory structure. So all of my development projects are now under "C:\projects" instead of just "C:\".

I want to replace all the old pathnames with the new (so my VCS will see the files on my local machine). In order to do that I have to run a query to change the data in the path field of the modules table. The problem is that a query like this fails:

select * from modules
where path like 'c:\\psoc%';

The query runs, but return zero rows. It should return about 100 rows. I think either the colon or the backslash (even though escaped) is causing problems. How do I run this query?