How to change the query value using hook_views_query_alter?
function zed_views_query_alter(&amp;$view, &amp;$query) {
  if ($view-&gt;name == 'questions_home' &amp;&amp; $view-&gt;current_display == 'rates_related') {
    foreach($query-&gt;where[1]['conditions'] as $idx =&gt; $condition) {
      if (!is_object($condition['field']) &amp;&amp; $condition['field'] == 'node.title') {
        $query-&gt;where[1]['conditions'][$idx]['value'] = '%whateveryoulike%';
        // or you can unset this condition and write down a new one
        // unset($query-&gt;where[1]['conditions'][$idx]);
        // $query-&gt;add_where_expression('1', "$field LIKE %" . db_like("california") . "% OR field LIKE %" . db_like("somethingelse") . "%");
      }
    }
    dpr($query-&gt;where[1]['conditions']);
  }
}