SORT by a text string

[Esqulax]

Is it possible to sort by a text string?

say.. Small, Medium and Large.

Or to compare a text string in an SQL statement... so....
sql = "SELECT * FROM db WHERE $something = 'small' " ;

[edited by: Esqulax at 5:54 pm (utc) on Feb. 22, 2008]

[PHP_Chimp]

Have a look at [dev.mysql.com...]
as you may be able to use LIKE