Google Bigquery

[RifkiAchmad]

Greetings , 

Iam Rifki

I have some litte problem about syntax in Bigquery

How We using 'Like' order 

In SQL 

-SELECT *  

-FROM `dam13junrifki.rifkidata.transaksi` 

-Where Gender = 'Male'

-and Device_Type = 'Mobile'

-and Date Like (%2013) ;

However this not work in Bigquery

Could you all helme me guys?

Big Thanks

[kolban]

If we look here ... we find that LIKE is indeed a supported comparison operator.  In your question, you said that something didn't work.  Can you elaborate on that?  Can you describe exactly what you tried and exactly what the error symptom was?

[RifkiAchmad]

Thanks for respond

i have got the answer :

SELECT *  

FROM `dam13junrifki.rifkidata.transaksi` 

where gender = 'Male'

and Device_Type = 'Mobile'

and Product = 'Books'

and Customer_Login_type = 'Member'

and EXTRACT(YEAR FROM date) = 2014

and EXTRACT(MONTH FROM date) = 01

i must use "extract' syntax to determine the year or date that i want to know