replace function

The replace function returns the source with every occurrence of the search string replaced with the replacement string.

returnvalue replace(source, search_string [, replacement_string])

source ::= any*
search_string ::= any*
replacement_string ::= any*
returnvalue ::= string

Example: Replace the source location of the passenger with ticket number 1762320569757 from SFO to SOF.

SELECT replace(bag.bagInfo[0].routing,"SFO","SOF") 
FROM baggageInfo bag
WHERE ticketNo=1762320569757

Output:

{"Column_1":"SOF/IST/ATH/JTR"}

Example 2: Replace the double quote in the passenger name with a single quote.

If your data might contain a double quote in the passenger's name, you can use replace function to change the double quote to a single quote.

SELECT fullname, 
replace(fullname, "\"", "'") as new_fullname
FROM BaggageInfo bag