function search_autocomplete_update_6202 in Search Autocomplete 6.2

Get ready for version 2.1 to 2.2

File

./search_autocomplete.install, line 319

This file is used to install/update/delete the module tables in database

Code

function search_autocomplete_update_6202() {
  $ret = array();
  $results = db_query('SELECT sug_query FROM {search_autocomplete_suggestions}');
  while ($item = db_fetch_array($results)) {
    $new_query = str_replace("LIKE LOWER('%%%s%%')", "LIKE #", $item['sug_query']);
    db_query('UPDATE {search_autocomplete_suggestions} SET sug_query = "%s" WHERE sug_query = "%s"', $new_query, $item['sug_query']);
  }
  return $ret;
}