Posted by 2525 on 07/12/07 22:44

In article <5fngvtF3cuhupU1@mid.individual.net>,
paul.lautman@btinternet.com says...
> 2525@virgin.co.uk wrote:
> > I'm not very familiar with SQL - Using mySQL
> >
> > I need to add or remove prefixes from table names - can anyone tell me
> > an SQL (or PHP for that matter) way to do this please?
> >
> > I can't seem to find a way to do it.
> >
> > thanks
> >
> > cleo
>
> Your question does not make sense. Maybe some examples of what you are
> trying to say may help.
>
>
>

I need to rename all the tables in my databases by changing the first few
characters of each table name:

eg
my_email to email
my_zips to zip

There are many tables and hand changing one at a time is not feasible.
I can't find an SQL statement that will do something like

rename TABLE * where TABLENAME = my_* TO *

ie dropping the my_ part.

How can I do this either with SQL (prefered) or PHP if needs be.

cleo

[Back to original message]