how to execute year(date)mysql query in tmysqlinput component

[bhagyarekha]

HI All

Am trying to execute 

SELECT * FROM a where year(timestamp_column)='2017';

in tmysqlinputcomponent .but am unable to get the result.can any one tell me the solution

"SELECT
`products_urls`.`id`,
`products_urls`.`modified`
FROM `products_urls` where YEAR( modified)='2017'"

this is my query in tmysqlinputcomponent

Thanks

Rekha

[Anonymous]

You mean you get no rows from the input component? 

A screenshot would be very helpful.

[bhagyarekha · Accepted solution]

ya thank you i got solution i missed `modified` for modified .

now it is working fine

[Anonymous]

oh alright cool.