[SalesForce] Query Opportunity Tasks from developer console

I want id's of tasks related to Opportunity. I tried below in developer console query editor,

select id,createdDate from Task where whatid like '006%'

But its giving me error,

Invalid_Query_Filter_Operator

Its giving description as like operator cannot be used for Id field.

How can i query it from query editor then?

Best Answer

You could try

[SELECT Id 
 FROM Task 
 WHERE WhatId IN  (SELECT Id FROM Opportunity)
]);