Tag: Select query

SELECT * or SELECT column1, colum2, column3, etc

Which is faster/best? in PHP I’ve heard that SELECT * is generally bad practice to use when writing SQL commands because it is more efficient to SELECT columns you specifically need. If I need to SELECT every column in a table, should I use SELECT * FROM TABLE or SELECT column1, colum2, column3, etc. FROM