Issue

So, I have this Query:

SELECT id, name FROM artist WHERE artist.name LIKE '%feat.%'

From which, the results are these:

If I place parenthesis around the Query like this:

(SELECT id, name FROM artist WHERE artist.name LIKE '%feat.%')

From which, the results are these:

The results change! Why? It's not like there is some kind of Order of Operations. It's one SELECT alone sitting there.

Would you like to reproduce it? Here's the link to the database's data and schema.

Solution

Seems like it's a phpmyadmin 4.6.3 bug since it's not something else.

Answered By - Eksapsy