MySQL query to find and replace a string in field names

Question

Is there a mysql query to find and replace parts of field names?

I know you can do that within the actual data using

update [table_name] 
   set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

... but how do you do that for the actual field names?

I have some fields with a - in the name, and I'd like to replace them all with a _

RyanHennig · Accepted Answer · 2010-08-01 02:16:09Z

1

To change the column names, you'll need to use the ALTER TABLE command.

Here's a solution in pseudocode:

Get all table names
Foreach t in table names
  Foreach columnname in t containing '-'
    newname = old name with "-" replaced with "_"
    "ALTER TABLE <tablename> CHANGE <columnname> <newname>"
  End
End

answered Aug 1, 2010 at 2:16

RyanHennig

1,0729 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL query to find and replace a string in field names

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related