Topic on Talk:Quarry

"select *" returns different rows from "select col_name"?

2
RoySmith (talkcontribs)

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.

Matěj Suchánek (talkcontribs)
Reply to ""select *" returns different rows from "select col_name"?"