Condition::translateCondition

public static Condition::translateCondition(&$condition, SelectInterface $sql_query, $case_sensitive)

public static function translateCondition(&$condition, SelectInterface $sql_query, $case_sensitive) {
  // // There is nothing we can do for IN ().
  if (is_array($condition['value'])) {
    return;
  }

  // Ensure that the default operator is set to simplify the cases below.
  if (empty($condition['operator'])) {
    $condition['operator'] = '=';
  }
  switch ($condition['operator']) {
    case '=':
      // If a field explicitly requests that queries should not be case
      // sensitive, use the LIKE operator, otherwise keep =.
      if ($case_sensitive === FALSE) {
        $condition['value'] = $sql_query->escapeLike($condition['value']);
        $condition['operator'] = 'LIKE';
      }
      break;
    case '<>':
      // If a field explicitly requests that queries should not be case
      // sensitive, use the NOT LIKE operator, otherwise keep <>.
      if ($case_sensitive === FALSE) {
        $condition['value'] = $sql_query->escapeLike($condition['value']);
        $condition['operator'] = 'NOT LIKE';
      }
      break;
    case 'STARTS_WITH':
      if ($case_sensitive) {
        $condition['operator'] = 'LIKE BINARY';
      }
      else {
        $condition['operator'] = 'LIKE';
      }
      $condition['value'] = $sql_query->escapeLike($condition['value']) . '%';
      break;

    case 'CONTAINS':
      if ($case_sensitive) {
        $condition['operator'] = 'LIKE BINARY';
      }
      else {
        $condition['operator'] = 'LIKE';
      }
      $condition['value'] = '%' . $sql_query->escapeLike($condition['value']) . '%';
      break;

    case 'ENDS_WITH':
      if ($case_sensitive) {
        $condition['operator'] = 'LIKE BINARY';
      }
      else {
        $condition['operator'] = 'LIKE';
      }
      $condition['value'] = '%' . $sql_query->escapeLike($condition['value']);
      break;
  }
}