Split up a column into multiple columns in MySQL database?

[jmyrtle]

@r937

as for splitting up the name column, do that in php, where it’ll be a lot easier than in sql

That’s what I’m trying to do:

@droopsnoot

If there’s a rule, then you could do it as a query or a short bit of PHP code. For example if the format is always surname, followed by a comma, followed by the first name, then you could write a short bit of PHP to read every row, split the names, and write it back.

How would I be able to do that?

@Mittineague

I think there should be some here that could help if you would prefer to start a topic in General Web Dev