quick SQL definition needed

[dominatrix1]

qhat does the * sign mean in sql

 

[Inquisitor]

It matches all fields in a table, e.g.

SELECT * FROM `table`

will expand to

SELECT `field1`, `field2`, `field3` FROM `table`

for a table with fields called field1, field2 and field3.

 

[dominatrix1]

cheers

 

[Beerbaron]

* = all

 

[SpicyDuck]

* = me, tbqfh.