/** * Determine whether the given value exists. * @param DB\Table $table * @param DB\Column $column * @param mixed $value */ protected function value_exists($table, $column, $value) { $wpdb = $table->get_database()->get_wpdb(); $sql = 'SELECT 1 FROM `' . $table->get_name() . '` ' . 'WHERE `' . $column->get_name() . '` = %s ' . 'LIMIT 1'; $exists = $wpdb->get_row($wpdb->prepare($sql, array($value))); return !is_null($exists); }