MYsql Reterive specified data only

[maverick]

Hi

my code is below
put "SELECT * FROM " & tTableName into tSQL
the code above get all data from My Db
i need to get where username='xxx'
how to code where query ..

[LCNeil]

Dear Maverick,

Thank you for your request.

I believe you are looking to use something like the SQL WHERE clause.

The following should explain this in more detail and give a workable example

http://www.w3schools.com/sql/sql_where.asp

Kind Regards,

Neil Roger
--
RunRev Support Team ~ http://www.runrev.com
--

[maverick]

Hi

Thanks for ur reply..
Am here how to use in live code .. i got it .
here is the below code
put "SELECT * FROM " & tTableName & " WHERE username="&'xxx' into tSQL