$s = $_POST[\'submitterms\'];
$querystr = "
            SELECT $wpdb->terms.*
            FROM $wpdb->terms
            WHERE
            lower($wpdb->terms.name) like \'%$s%\'
         ";
$pageposts = $wpdb->get_results($querystr, OBJECT);
echo \'<ul>\';
$x = 0;
while ($pageposts[$x]) {
  $post = $pageposts[$x];
  echo \'<li>\';
  echo \'<a href="\' . $post->term_id . \'">\' . $post->name . \'</a>\';
  echo \'</li>\';
  $x++;
}

echo \'</ul>\';

我能够获得包含我在文本框中键入的字符的术语名称。

但我想做的是改变term_id AS id AND name AS value 这样我就可以传递如下变量：

$post->id
$post->value
//i.e
echo \'<a href="\'.$post->id.\'">\'.$post->value.\'</a>\';

我想我需要更改MySQL代码。我该怎么办？

$querystr = "SELECT `term_id` AS `id`, `name` AS `value`, `slug`, `term_group` FROM {$wpdb->terms} WHERE lower($wpdb->terms.name) like \'%$s%\'";