mysql返回表的一列,MySQL 5.7根据不同的列返回表的所有列

I just upgraded to MySQL 5.7 and unfortunately for me, some of the functionality of GROUP BY is gone. I wanted to select all movies from my movies table with as long as the movies.id of type int is not a duplicate. My previous query in MySQL 5.6 was:

SELECT *

FROM movies

WHERE movies.title LIKE '%example%'

GROUP BY movies.id

If I had two movies with the same id, it would only display one movie, instead of that movie and its duplicates.

When I upgraded to MySQL 5.7, the GROUP BY gave me errors and I was instead told to use ORDER BY. However this query:

SELECT *

FROM movies

WHERE movies.title LIKE '%example%'

ORDER BY movies.id

Does return duplicate movies. So, is there a way to filter this out, and only return a row if it isn't a duplicate?

Edit: For example if this is my movies table:

movies

==================

| id | title |

==================

| 1 | example |

------------------

| 2 | example |

------------------

| 1 | example |

------------------

Here is the output of each query:

Previous query result (with MySQL 5.6)

=======

1 | example

2 | example

New query result (with MySQL 5.7 and ORDER BY)

=======

1 | example

1 | example

2 | example

I want the final result to contain no duplicates (so the result should look like the first query result).

Edit 2: I understand I was sort of abusing the way MySQL handled GROUP BY. Unfortunately, I do not have much experience with MySQL and got that answer from StackOverflow. I would just like to return all columns in my table that do not contain duplicate ids.

解决方案

I believe would be easy to use distinct keyword

SELECT distinct movies.*

FROM movies

WHERE movies.title = 'example'