ConcatWs
extends FunctionNode
in package
Usage: CONCAT_WS(SEPARATOR, STR1, STR2, ... [ NOTEMPTY ])
CONCAT_WS() stands for Concatenate With Separator and is a special form of CONCAT(). The first argument is the separator for the rest of the arguments. The separator is added between the strings to be concatenated. The separator can be a string, as can the rest of the arguments. If the separator is NULL, the result is NULL.
The function is able to skip empty strings and zero valued integers by passing the parameter NOTEMPTY. This removes the need to wrap expressions in NULLIF statements when wanting to avoid empty values between separators.
Tags
Table of Contents
Properties
Methods
Properties
$notEmpty
private
mixed
$notEmpty
= false
$values
private
mixed
$values
= array()
Methods
getSql()
public
getSql(SqlWalker $sqlWalker) : mixed
Parameters
- $sqlWalker : SqlWalker
parse()
public
parse(Parser $parser) : mixed
Parameters
- $parser : Parser