function search_autocomplete_update_6203 in Search Autocomplete 6.2

Get ready for version 2.2 to 2.3

File

./search_autocomplete.install, line 332

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

Code

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