$query = $[wpdb](http://codex.wordpress.org/Class_Reference/wpdb)->prepare("SELECT `ID` FROM $[wpdb](http://codex.wordpress.org/Class_Reference/wpdb)->posts WHERE `guid` LIKE '%s' AND `post_type` LIKE 'attachment'", ['%' . $value]);

Codex Entries