This is my SQL Queries
SELECT top 1000 tr.page,tr.referrer,tr.keywords,tr.ms_id,tr.ms_date,tr.ip FROM tblTracking tr
WHERE tr.heirarchy LIKE '%*' + cast(@Cid as varchar) + '*%' and tr.site=@site and
tr.ms_date between CONVERT(VARCHAR(11),@FromDt,101) and DATEADD(DAY,1,CONVERT(VARCHAR(11),@Todt,101))
order by tr.ms_date desc
I converted it into Mysql
SELECT COUNT(tr.id) as cnt FROM tblTracking tr
WHERE tr.heirarchy LIKE '%*'; + concat(cast(p_Cid as varchar(1)) , '*%') and tr.site=p_site and
tr.ms_date between DATE_FORMAT(p_FromDt,'%m/%d/%Y') and TIMESTAMPADD(DAY,1,DATE_FORMAT(p_Todt,'%m/%d/%Y'))
Its giving me error
'+ ' not valid at this position excepting :END
When i removed ";" it give me following Error
'+ ' not valid at this position excepting: ';'
What I have tried:
I tried everything but couldn't get any thing