On Monday 28 January 2008 03:51:28 pm Wade Preston Shearer wrote:
> The AS option in an SQL command allows you to rename a field, like this:
>
> select username as user, password as secretcode
>
>
> Is it possible to rename all of the fields that you pull at once?
> Here's what I want to do:
>
> I have a table of fields that are all named with the same prefix. I
> want to rename them as they are pulled from the DB with a different
> prefix. Is that possible?
MySQL (nor any other RDBMS, AFAIK) does not have any function that will do
this for you, but from within PHP, it wouldn't be hard to write a simple
loop. Here's an overview (I don't have time right now to write up the code,
sorry):
1. $fields = "DESCRIBE TABLE db.table"
2. $query = "SELECT ";
3. foreach ($fields as $field) { $query += $field."AS ".(preg_replace
('/^old_prefix_/', 'new_prefix_', $field)).", "; }
4. Add any other query elements, like a WHERE clause.
5. Run the $query.
I think that method would be pretty simple to implement and should work with
just about any SQL RDBMS.
--
Lamont Peterson <[EMAIL PROTECTED]>
Founder [ http://blog.OpenBrainstem.net/peregrine/ ]
GPG Key fingerprint: 0E35 93C5 4249 49F0 EC7B 4DDD BE46 4732 6460 CCB5
___ ____ _ _
/ _ \ _ __ ___ _ __ | __ ) _ __ __ _(_)_ __ ___| |_ ___ _ __ ___
| | | | '_ \ / _ \ '_ \| _ \| '__/ _` | | '_ \/ __| __/ _ \ '_ ` _ \
| |_| | |_) | __/ | | | |_) | | | (_| | | | | \__ \ || __/ | | | | |
\___/| .__/ \___|_| |_|____/|_| \__,_|_|_| |_|___/\__\___|_| |_| |_|
|_| Intelligent Open Source Software Engineering
[ http://www.OpenBrainstem.net/ ]
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
