Re: Need one table with two names

[Peter Brawley]

> it would require me to find and edit every "zips" table query string in the code.

?! You would change those SELECT statements if and only if you wished to make the change described in your original post.

> And, my selects are seldom "*" and often something unique.

Makes no diff. Given ...

create or replace view postalcodes as select * from zips;

you can write ...

select this_specific_column from postalcodes;

> What I've been hoping for is a change that can be applied to the database outside of any changes to query strings.

You can implement any name preprocessing conventons you please in your apps, but MySQL knows nothing about preprocessors.

PB