MySQL Obtain Multiple Columns

Question

how would one achieve the ability to select multiple columns that are similar in the statement below? I'm using the DISTINCT MySQL for the body, which works fine... but I cannot obtain additional information (columns) that goes with it. Any ideas would be appreciated, please let me know if you need more information from me.

SELECT DISTINCT T.body
FROM Posts T
   LEFT JOIN Posts T2 ON T.body != T2.body
WHERE T.body LIKE CONCAT('%', T2.body, '%')
UNION 
SELECT DISTINCT T2.body
FROM Posts T
   LEFT JOIN Posts T2 ON T.body != T2.body
WHERE T.body LIKE CONCAT('%', T2.body, '%')
ORDER BY body;

XxXk5XxX · Accepted Answer · 2014-09-10 02:20:24Z

1

Try adding column that you want to select. for example

SELECT DISTINCT T.body, T.Column1, T.Column2 FROM Posts T LEFT JOIN Posts T2 ON T.body != T2.body WHERE T.body LIKE CONCAT('%', T2.body, '%') UNION SELECT DISTINCT T2.body FROM Posts T LEFT JOIN Posts T2 ON T.body != T2.body WHERE T.body LIKE CONCAT('%', T2.body, '%') ORDER BY body;"

answered Sep 10, 2014 at 2:20

XxXk5XxX

518 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user2793987 Over a year ago

I receive the following error with that statement, although it's close: #1222 - The used SELECT statements have a different number of columns ; What should I do to correct this?

user2793987 Over a year ago

SELECT DISTINCT T.body, T.IDPosts, T.latitude, T.longitude, T.post_date FROM Posts T LEFT JOIN Posts T2 ON T.body != T2.body WHERE T.body LIKE CONCAT('%', T2.body, '%') UNION SELECT DISTINCT T2.body FROM Posts T LEFT JOIN Posts T2 ON T.body != T2.body WHERE T.body LIKE CONCAT('%', T2.body, '%') ORDER BY body;

XxXk5XxX Over a year ago

Try make the same number of columns on your first select to the your second select. I mean the columns that you select mus be equal.

Collectives™ on Stack Overflow

MySQL Obtain Multiple Columns

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related