parizek.com
MySQL how to remove prefix/suffix e.g. leading/trailing quotes from a column of strings
update table set column = trim(BOTH ‘”‘ FROM column); For example, above removes the leading and trailing (prefix/suffic) quotes that excel adds upon csv export. You could Select …