Q:

MySQL automatically change columns

I'm really bad in MySQL, and I really don't know is it even possible. But I have 6k records and don't want to do it manually.
I have to columns: Name and Slug. Names can be different, for example Dancer, Hip Hop, Rock (hard). 
And what I want to do is for each record change Slug automatically depending on Name, with converting to slug. For example, for Dancer do dancer, for Hip Hop => hip-hop, for Rock (hard) => rock-hard.
Is it even possible?

A:

You should be able to update all your slugs in 1 query using LCASE() and REPLACE(). Something like this should work:
update mytable set Slug=lcase(replace(Name, ' ', '-'));

