How to limit?

[#1]

Hi there,

I need to limit the content of the two fields: one is open data, between 2014/06/01 and 2014/07/01; the other is country, include China, Hong Kong, Taiwan, Japan and Korea.

I want to know how to limit? thank you!

[#2]

Hello Andrew,

one more question:

I want to filter field ' work_group' include 'CN', 'JP', 'KR'. such as ' CNA_CCR', 'CNB_CCR', 'JPD_GCC' etc.

Could you please help me?

[#3]

WHERE Work_Group in ('Administration', 'Call Administrator', 'System Administrator') OR Work_Group like '%CN%' OR Work_Group like '%JP%' OR Work_Group like '%KR%'

mark as answered if this resolves your question

[jer_2011]

try with:

where work_group in ( 'CHINA', 'JAPAN','COREA')