Selecting fields from tables with conditionals

[chromonium]

Hi,

Is it possible to select fields in a table that for instance have a 'f' at the beginning, in the MySQL query, and not the others in the table?

regards

adam

 

[swampBoogie]

select * from t where substring(c1 from 1 for 1) = 'f'

 

[chromonium]

cheers