Replace in SQL
I have a column which is bringing in some field values in between crotchets or square brackets [ ] and also in between inverted commas " " BUT not all values come through like this.
I am trying to write a SQL to drop the [ ] and " " in the front and back of the values.
im using REPLACE(REPLACE(`COLUMN NAME`, '[', ' '), ']', ' ');
But it isnt working.
Can anyone assist?