How to customize default wordpress search query

I believe you are looking for this

$mydb = new wpdb('username','password','database','localhost');
$rows = $mydb->get_results("select Name from my_table");
echo "<ul>";
foreach ($rows as $obj) :
  echo "<li>".$obj->Name."</li>";
endforeach;
echo "</ul>";