On 20 May 2016, at 17:35, Jaromir Obr wrote: > Expected result: > ---- > SELECT REPLACE(ingredients,'enriched_','') as item_ingredients > FROM baked_goods; > > Actual result: > ---- > FROM baked_goods; > > Note: It works well in MariaDB shell, in the same terminal
Either way has its advantages. I find keeping the original line-folding more convenient for both readability and making corrections than having the line wrapped (often splitting a token) at the edge of the window. I can also why you and others might prefer UP/RETURN to UP/UP/RETURN/UP/UP/RETURN. Best regards, Niall O'Reilly