mysql - 在插入到 wordpress 中的自定义数据表之前合并来自 csv 的数据

Question

我有一个 MySQL 查询，它过滤来自 csv 文件的所有电子邮件，并在将它们插入到 wordpress 中的自定义数据表之前组合多条记录。这有效：

$cntSQL = "SELECT count(*) as count FROM {$tablename} WHERE email='".$email."'";

但我需要一个像下面这样的多重条件，但这不起作用

$cntSQL = "SELECT count(*) as count FROM {$tablename} WHERE email='".$email."' AND phone='".$phone."'";

我也试过这个但没有工作。

$cntSQL = "SELECT count(*) as count FROM {$tablename} WHERE {email='".$email."'} AND {phone='".$phone."'}";

调试

[09-Oct-2020 18:49:07 UTC] WordPress database error  for query INSERT INTO `wp_lubuvna_subscribers` (`first_name`, `last_name`, `email`, `phone`, `birthday`, `gender`, `customer_type`, `id_company_number`, `street_address`, `address_line_2`, `city`, `state_area`, `zip`, `customer_from`, `groups`, `last_visit`, `send_sms`, `send_email`, `join_date`, `post_author`) VALUES ('Joshua', 'Hodges', '[e-mail]', '[phone]', '04/25/1953', 'Male', '499242365', '79808607399', 'Jomuz Street', 'Alser Grove', 'Custipeva', 'MO', '41789', 'tada', 'pacseztoj', '08/20/1988', 'TRUE', 'TRUE', '01/10/1920', 1) made by do_action('wp_ajax_new_subscriber_batch'), WP_Hook->do_action, WP_Hook->apply_filters, maybe_insert_new_subscriber_batch_database_table

我从以下得到的结果：

$record = $wpdb->get_results($cntSQL, OBJECT);
results:
Array ( [0] => stdClass Object ( [count] => 0 ) ) 

标签： mysqlsqldatabasewordpressdatatable

Answer 1

根据您的评论，您需要OR操作员而不是AND操作员。

$cntSQL = "SELECT count(*) as count FROM {$tablename} WHERE email='".$email."' OR phone='".$phone."'";