Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

CONCAT_WS() concat function we can use for adds two or more expressions together with a separator or delimeter.

SELECT concat_ws("||",concat("ZIP: ",client_zip), concat("Phone: ",client_phone)) 
FROM `user_contacts` ORDER BY client_id DESC LIMIT 1

O/P:
ZIP: 334455||Phone: 2233443344
 
PREVIOUS NEXT
Tagged: #concat #function #adds #expressions #separator
ADD COMMENT
Topic
Name
7+7 =