Assistance with selecting backslash slash combination

[Jeff Foydl]

Hello, I have what is hopefully a simple question, but I have been unable to properly resolve on my own.

We have a WordPress website and need to query the tables for a particular plug in for records where our website manager used an explicit path vs. the relative path for images. This plugin stores URLs in the format 'http:\/\/site.domain.com' along with other data in the text field.

When I try "SELECT * FROM table WHERE parameter like '%http:\/\/site.domain.com%'" I get no records returned. I'm able to select with any clause that excludes the "\/\/" combination, but we're hoping to use this with REPLACE to bulk update all of the explicit paths to relative paths, so I need to be able to select the specific text. I've tried escaping the backslash ("\\/\\/") but that didn't help.

Any suggestions would be appreciated.

Thanks.