The functions used to connect strings in a MySQL tenant are concat and concat_ws. "||" is the logical operator for "OR".
SQL statement for querying the name of a customer in a MySQL tenant:
obclient> SELECT concat_ws(' ', c_first, c_last) full_name FROM cust ORDER BY c_last LIMIT 2;
+---------------------------+
| full_name |
+---------------------------+
| fvBZoeIV2uJh7 ABLEABLEESE |
| dHmIgRV1IsC ABLEABLEOUGHT |
+---------------------------+
2 rows in set (0.01 sec)
If you add the PIPES_AS_CONCAT mode to the sql_mode variable of a MySQL tenant, "||" also functions as a string connector. SQL statement:
obclient> SET SESSION sql_mode='PIPES_AS_CONCAT,STRICT_TRANS_TABLES,STRICT_ALL_TABLES';
obclient> SELECT c_first || ' ' || c_last full_name FROM cust ORDER BY c_last LIMIT 2;
+---------------------------+
| full_name |
+---------------------------+
| fvBZoeIV2uJh7 ABLEABLEESE |
| dHmIgRV1IsC ABLEABLEOUGHT |
+---------------------------+
2 rows in set (0.01 sec)