要列出employee表中employee_state='t'的記錄怎麼寫Sql請句.

Question

query1.sql.add('select * from employee where employee_state='.....),不會了.特別是標點不知該怎麼用.請幫手.

Answer 1

query1.sql.add('select * from employee where employee_state=''t''');

Answer 2

query1.sql.add('select * from employee where employee_state'+#39+'t'+#39)

Answer 3

query1.sql.add('select * from employee where employee_state=''t''');

Answer 4

query1.sql.add('select * from employee where employee_state='''+edit1.text+'''');