In MySQL is there a way to chose one column over another when doing SELECT *?

Question

Ok, for a moment, throw out of your mind "good database design". Let's say I have two tables, and they have some of the same columns.

item
-------
id
title
color

and

item_detail
-------
id
weight
color

In a good normal query, you'd choose the columns you want within the query, like so:

SELECT item.title, item_detail.color, item_detail.weight ...

But what if you are stuck with a query that was built with star/all:

SELECT * ...

In this case you would get two color columns pulled back in your results, one for each table. Is there a way in MySQL to chose one color column over the other, so only one shows up in the results, without a full rewrite of the statement? So that I could say that the table item_detail takes priority?

Probably not but I thought I'd ask.

SELECT item.*, item_detail.weight ? or this, but it doesnt look pretty: https://stackoverflow.com/questions/9122/select-all-columns-except-one-in-mysql — Andrew, Oct 12 '17 at 00:22
I know. I inherited the problem and was looking for an interesting solution out. — Ethan Allen, Oct 12 '17 at 00:29

Eli Algranti · Accepted Answer · 2017-10-12T00:51:56.103

1

Err. No there is not.
But define "without a full rewrite of the statement". As far as I can see you'd just need to rewrite the select * portion of the query.
If you cannot touch the statement at all, then you are free to ignore the column in your application (the order of the columns does not change between calls)... or you could create a view...
It's hard to know which constraints you are dealing with when you say "But what if you are stuck with a query".

edited Oct 12 '17 at 00:51

answered Oct 12 '17 at 00:24

Eli Algranti

8,707
2
42
50

"stuck with a query" means I inherited the problem. – Ethan Allen Oct 12 '17 at 00:30
1

Then just change the query. You should not use `select *` anyway. – Eli Algranti Oct 12 '17 at 00:50
I just went ahead and did that. Thanks. – Ethan Allen Oct 12 '17 at 17:25

In MySQL is there a way to chose one column over another when doing SELECT *?

1 Answers1