I have a table which holds the status of peoples orders. It holds information on order_id
Different letters are printed automatically according to the status of the order.
However when the status is 'Dispatch' i need two letters to be printed.
I have tried
This only prints the first letter, (the DPTdoc) but not the second (DPT2doc).
Insert into orderstatus (order_id,order_status,
order_desc, letter) values('025', 'Dispatched', 'Black tailored coat ','DPTdoc DPT2doc');
Does anyone have any ideas on how to fix this?
Yes, normalize your data. Multiple values do not belong in a single column.