News for hackers. Stuff that matters.
Re:Why SELECT * is bad for SQL performance (2020) by hnlmorg on Monday February 15, 2021 @08:15AM (#26142404)
Unless I'm misunderstanding, what you're talking about there isn't wildcard selects but rather SELECT's without any filtering.

ie having `SELECT id, firstname, surname FROM people` would still catch 'A1234567890' and '123Smith!!!'

Where as `SELECT * from people WHERE id REGEXP '^[0-9]+$'` would exclude them despite being a wildcard SELECT.

There are no comments on this comment yet.