When I run:
select rd_title from redirect where rd_title like 'The\_%' limit 5;
I get:
The_"5"_Royales |
The_"5"_Royales |
The_"5"_Royales |
The_"5"_Royales |
The_"5"_Royales |
If I replace the explicit column name "rd_title" with "*", I get different rows:
select * from redirect where rd_title like 'The\_%' limit 5;
2751 | 0 | The_Angry_Brigade | ||
2903 | 0 | The_Diary_of_a_Young_Girl | ||
3317 | 0 | The_Birth_of_a_Nation | ||
3920 | 0 | The_Beatles | ||
4238 | 0 | The_Bronx |
What's going on here? I expected to get the same rows, just more columns.