I am fairly new to php / MySQL and have a problem with a query and an insert.
I have a database that maybe isn't the best design - it includes a field "Former Names" which is varchar 255.
It contains a list of names separated by commas. e.g.: "Svea Jarl, Apollo III "
There may be up to half a dozen or so different names in the one field.
(I know, I know - bad design - that's why I want to change it)...