/**
* Concatenates an array of column names or values.
*
* Usage:
* $query->select($query->concatenate(array('a', 'b')));
*
* @param array $values An array of values to concatenate.
* @param string $separator As separator to place between each value.
*
* @return string The concatenated values.
*
* @since 2.0
*/
public function concatenate($values, $separator = null)
{
if ($separator) {
return 'CONCATENATE(' . implode(' || ' . $this->query->quote($separator) . ' || ', $values) . ')';
} else {
return 'CONCATENATE(' . implode(' || ', $values) . ')';
}
}
