>>>>> "Ed" == Ed Carp <erc@stripped> writes:
Ed> Can the output of "SHOW COLUMNS" be manipulated? I have this table whose
Ed> field names collide with SQL, so I've prepended "X_" to every field name.
Ed> I'd like to chop off the "X_" when filling a list box for a user. I'm
Ed> doing this in HTML, so I can't manipulate the output of "SHOW COLUMNS"
Ed> If I were going to do this in a regular query, I could do something like
Ed> "select substring(xxx from 3) ...", but it seems I can't do something like
Ed> this to SHOW queries. :(
Sorry, but for the moment this isn't possible.
We plan to make 'surrogate' tables of the output from all SHOW
commands. When this is done you will be able to manipulate the columns
data like you would from a normal table.