$wpdb->prepare with LIKE and sprintf

Well, since I haven’t used a LIKE in a plugin in a while, it seems I missed this one.

WP is now adding ‘placeholders’ whenever you prepare or esc a query. The short solution I found was to do this. It may not be the proper one, but it works.

$sql = $wpdb->remove_placeholder_escape($wpdb->prepare("SELECT ID FROM $ignore_url_table_name where '%s' LIKE CONCAT('%',url,'%')",$urlRequested));