$wpdb->prepare syntax confusion


$wpdb->prepare syntax confusion

挣扎着看为什么这没有返回任何东西-很确定这是我的语法错误(wp_rg_lead_detail表中肯定有行,field_number为2,值为Trys)

function manageGetSearchEntries( $query ) {
    global $wpdb;
    $fullQuery = "SELECT * FROM wp_rg_lead_detail WHERE (%s, %s) = (%d, %s)";
    $result = $wpdb->get_results( $wpdb->prepare( $fullQuery, $query[0], $query[1], $query[2], $query[3] ), ARRAY_A );
    return $result;
}
$entryData = manageGetSearchEntries( array( 'field_number', 'value', 2, 'Trys' ) );

这不是有效的SQL。应该更像

WHERE (%s = %d) AND (%s = %s)