You should select as few rows as possible - e.g. if you have a table with 1,000,000 rows and your column only has 2,000 and you're selecting data only from that column, your database has less work to do. :)
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
How does:
work? It certainly returns less data but it shouldn't return fewer rows. I expect the where clause determines the returned rows.
You should select as few rows as possible - e.g. if you have a table with 1,000,000 rows and your column only has 2,000 and you're selecting data only from that column, your database has less work to do. :)