Make Views seach for LIKE

gistfile1.php

/**
 * Implements hook_views_query_alter().
 */
function devel_views_query_alter(&$view, &$query) {
  if (empty($query->where[1]['conditions'][1]['field'])) {
    return;
  }
  $sub_query = $query->where[1]['conditions'][1]['field'];
  if (!$conditions = &$sub_query->conditions()) {
    return;
  }

  if (!$conditions_2 = &$conditions[1]['field']->conditions()) {
    return;
  }

  $conditions_2[0]['value'] = '%' . $conditions_2[0]['value'] . '%';
  $conditions_2[0]['operator'] = 'LIKE';
}