function search_autocomplete_update_7201 in Search Autocomplete 7.2

Get ready for version 2.0 to 2.1

File

./search_autocomplete.install, line 303

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

Code

function search_autocomplete_update_7201() {
  $ret = array();
  $results = db_query('SELECT sug_query FROM {search_autocomplete_suggestions}');
  foreach ($results as $item) {
    $new_query = str_replace("LIKE LOWER('%%%s%%')", "LIKE(:like_word)", $item->sug_query);
    db_query('UPDATE {search_autocomplete_suggestions} SET sug_query = :sug_query WHERE sug_query = :new_query', array(
      ':sug_query' => $new_query,
      ':new_query' => $item->sug_query,
    ));
  }
  return $ret;
}