WordPress.DB.PreparedSQLPlaceholders.LikeWildcardsInQuery

Like Wildcards In Query

A SQL query is built in a way that Plugin Check cannot verify as safely prepared.

critical weight

Why It Shows Up

The scan found missing, incorrect, quoted, unsupported, or mismatched SQL placeholders around `$wpdb->prepare()` usage.

Why It Matters

Broken preparation can leave dynamic SQL values unsafe or make queries behave differently than intended.

How to Fix

  • Keep placeholders in the SQL string and pass dynamic values as separate arguments.
  • Use the placeholder that matches the value type.
  • Do not quote placeholders manually, and use allowlists for identifiers or SQL fragments.

Affected Plugins

RankPluginScoreErrorsWarningsInstallsUpdatedTop Issue
#51Media Cleaner: Clean your WordPress!2515139190k+Direct Query
#52Smart Manager – Advanced WooCommerce Bulk Edit & Inventory Management2538793510k+Not Prepared
#53Pay with Vipps and MobilePay for WooCommerce258455095k+Output Not Escaped
#54WP Google Review Slider251,3672,58230k+Non Prefixed Variable Found
#55Perfect Images: Regenerate Thumbnails, Image Sizes, WebP & AVIF2515411860k+Non Prefixed Variable Found
#56WPCargo Track & Trace2523955710k+Non Prefixed Variable Found
#57Open User Map – Interactive Leaflet Maps2689398610k+Non Prefixed Variable Found
#58SP Move Login268812156k+Text Domain Mismatch
#59Jetpack VaultPress287136210k+Missing
#60Database Cleaner2913529710k+Direct Query
#61Form Vibes – Database Manager for Forms3117628410k+Text Domain Mismatch
#62Thrive Automator32848410k+Not Prepared
#63SEOPress – AI SEO Plugin & On-site SEO32138429300k+Non Prefixed Variable Found
#64ThumbPress – Compress Images, Manage Thumbnails, Detect Image Issues, WebP/AVIF, Lazy Loading, Hotlinking & More3310128930k+Non Prefixed Variable Found
#65ReOrder Posts within Categories35392077k+Non Prefixed Variable Found
#66Yabe Webfont – Use Custom Fonts, Google Fonts or Adobe Fonts35481145k+Non Prefixed Hookname Found
#67Product Labels For Woocommerce (Sale Badges)36904810k+Output Not Escaped
#68Optimize Database after Deleting Revisions3664412760k+Output Not Escaped