MySQL field limiter?

[SilverVenom]

Hey, I am using FlashSQL v3 for my flash movie to communicate with my MySQL database. And my SQL query is:
"SELECT * FROM passes WHERE upper(uname)"+query

Where query is :
" LIKE'"+input.txt+"%'"

This returns everything in my "passes" table, which include uname, id, hash1, hash2 and pass. I am looking to make an interface where the user can choose which options they want loaded into the datagrid. Eg: Only uname and id, or uname, hash1, hash2. Ect.

So my question boils down to: Is there an SQL command which can restrict which Fields are returned? Thanks in advance! - Peter.

[jsebrech]

You can specify the field names instead of *:
SELECT UNAME, ID, HASH1 FROM PASSES WHERE UPPER(UNAME)...

[SilverVenom]

Thanks. :) That was exactly what I was looking for.

[finchou]

Hi,

I've just purchased FlashSQLv3 and I didn't find how to select a mySQL database. Could you help me ?

[boombastic]

Hi,
I've just posted as Finchou (a "ex-workmate"). You can reply with this alias.