How can i rewrite this sql script without using exists

Keywords´╝Ü mysql sql


I am new to sql. How can i rewrite the below script without using exists

select distinct oe.*, o.*, so.* ,ro.*
ms_bvoip_order_extension oe
inner join ms_order o on oe.ms_order_id = o.ms_order_id
inner join ms_sub_order so on so.ms_order_id = o.ms_order_id
inner join ms_job j on j.entity_id = so.ms_sub_order_id
inner join ms_task t on t.wf_job_id = j.wf_job_id 
where o.order_type = 900 
and o.entered_date between to_date('12/01/2018 00:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('12/31/2018 00:00:00','mm/dd/yyyy hh24:mi:ss') 
and j.entity_type = 5 
and exists 
( select 'X' 
from  ms_task t 
where (( like '%Error%') or ( like '%Correct%') or ( = '%Create AOTS Ticket%'))  
and t.job_id = hextoraw(j.wf_job_id) ) 
order by o.usrp_order_number;