mysql if_MySQL加入IF条件

I want to get some results via query simillar to:

SELECT

* FROM

users LEFT JOIN

IF (users.type = '1', 'private','company') AS details ON

users.id = details.user_id WHERE

users.id = 1

Any ideas?

解决方案SELECT * FROM users

LEFT JOIN private AS details ON users.id = details.user_id

WHERE users.id = 1 AND users.type = 1

UNION

SELECT * FROM users

LEFT JOIN company AS details ON users.id = details.user_id

WHERE users.id = 1 AND users.type != 1

I think that is what you are trying to do, isn't it?

As you have now said that the number of columns differs, you would need to specify the columns, e.g.

SELECT 'private' AS detailType, users.*, col1, col2, col3, '' FROM users

LEFT JOIN private AS details ON users.id = details.user_id

WHERE users.id = 1 AND users.type = 1

UNION

SELECT 'company', users.*, col1, '', '', col4 FROM users

LEFT JOIN company AS details ON users.id = details.user_id

WHERE users.id = 1 AND users.type != 1

In this example, private has columns col1, col2 and col3, whilst company has col1 and col4, but you want them all.