In MySQL utilizing the Transform property, my where clause is not delivering the expected results.

gbennett
gbennett ⚪️
in Connectors

In MySQL utilizing the Transform property, my where clause is not delivering the expected results.  I cannot limit the data I am pulling in thus using the transform property to only look at the date from 01-2016.  Here is a snippet of the code:  

 

SELECT
DATE_FORMAT(p.`date`,'%m-%Y') AS Date,
p.`Campaign`,
p.`Cost`,

CASE WHEN p.`Campaign` LIKE '%Something%' THEN 'Nothing'
WHEN p.`Campaign` LIKE '%AB%' THEN 'CD'
WHEN p.`Campaign` LIKE '%DE%' THEN 'FG'
WHEN p.`Campaign` LIKE '%ST%' THEN 'XV'
WHEN p.`Campaign` LIKE '%Change%' THEN 'Protect'
Else 'Logo'
END as Grouping

FROM `ppc_baseline` p

Where p.`Date` > 12-2015 AND p.`Cost` > 0

ORDER BY p.`Date` ASC

Best Answer

  • RGranada
    RGranada 🟢
    Accepted Answer

    Hi,

     

    Try this:

     

    SELECT
    DATE_FORMAT(p.`date`,'%m-%Y') AS Date,
    p.`Campaign`,
    p.`Cost`,

    CASE WHEN p.`Campaign` LIKE '%Something%' THEN 'Nothing'
    WHEN p.`Campaign` LIKE '%AB%' THEN 'CD'
    WHEN p.`Campaign` LIKE '%DE%' THEN 'FG'
    WHEN p.`Campaign` LIKE '%ST%' THEN 'XV'
    WHEN p.`Campaign` LIKE '%Change%' THEN 'Protect'
    Else 'Logo'
    END as Grouping

    FROM `ppc_baseline` p

    Where YEAR(p.`Date`) > 2015 AND p.`Cost` > 0

    ORDER BY p.`Date` ASC

     

    Hope this helps

Categories