CQL- Combining two fields in SELECT statement

CQL- Combining two fields in SELECT statement

In my cassandra (columnfamily)table I have a field "message1" and a field
"message2". I would like to select all records where message1 + space +
message2 is a certain value.
How can I concat or merge two fields(message1+message) into one in
select statement as in mysql
select message1 + ' ' + message2 as WholeMessage from MessageTable
where message1 + ' ' + message2 like '%MyWholeMessageString%'