我正在遍历一系列产品，并希望使用产品SKU创建OR字符串。

据我所知，您传递了一个查询和变量来替换SQL中的占位符。一个简化的例子是这样的。

$sql = "SELECT id, sku FROM document_product 
        WHERE 1=1
        AND sku LIKE %s
        OR sku LIKE %s
        OR sku LIKE %s";

$prep_sql = $wpdb->prepare($sql, [\'42ts\', \'55zb\', \'66bc\']);

$results = $wpdb->query($prep_sql, ARRAY_A);

$skus = [];
$skus_like = [];
foreach($matchedProducts as $matchedProduct) {
    $skus[] = $matchedProduct->sku;
    $skus_like[] = "product_sku LIKE %%%s%%";
}

$sql = "SELECT document_id, product_sku
        FROM document_product
        WHERE 1 = 1 AND (" . implode(\' OR \', $skus_like) . ")";

$prep_sql = $wpdb->prepare($sql, $skus);

$product_document_results = $wpdb->query($prep_sql, ARRAY_A);

Edit:当前错误

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near


\'%WPR2-100-10\\\\\'% 
OR product_sku LIKE %WPR2-100-10\\\\\'-LCD% 
OR product_sku LIKE %WPR\' 

at line 3 for query 

SELECT document_id, product_sku
FROM document_product
WHERE 1 = 1
AND (product_sku LIKE %APR2-100-10\\\\\'% 
OR product_sku LIKE %APTR2-100-10\\\\\'-BCD% 
OR product_sku LIKE %APTR2-100-20\\\\\'% 
OR product_sku LIKE %APTR2-100-20\\\\\'-BCD% 
OR product_sku LIKE %APTR2-30-10\\\\\'% 
OR product_sku LIKE %APTR2-30-10\\\\\'-BCD% 
OR product_sku LIKE %APTR2-30-20\\\\\'% 
OR product_sku LIKE %APTR2-30-20\\\\\'-BCD% 
OR product_sku LIKE %APTR2-300-10\\\\\'% 
OR product_sku LIKE %APTR2-300-10\\\\\'-BCD% 
OR product_sku LIKE %APTR2-300-20\\\\\'% 
OR product_sku LIKE %APTR2-300-20\\\\\'-BCD%) 

made by require(\'wp-blog-header.php\'), require_once(\'wp-includes/template-loader.php\'), include(\'/themes/the-theme/search.php\'), search_documents