I have a reasonably straightforward MySQL query as follows:

```
SELECT * 
FROM post INNER JOIN comment ON post.post_id = comment.post_id
WHERE post.host = 99999
ORDER BY post.post_id

```

My problem is that some of my column names are common to both the post and comment table. In the result, the column name appears only once, and its values are taken from the last table in the query (ie. the comment table).

I realise that I could explicitly list each column name in the `SELECT` part of the query, and use aliases to differentiate between duplicate column names, but there are a lot of columns in each table and it would be messy.

Is there a more efficient way to go about it?