Using LIKE '%%' with dates

[luckilian]

Hi there i have a problem with on mysql query ..
i want to extract all the data from mysql table within 2 months ..

SELECT 
  data_curenta,cod_produs,denumire,cantitate,pret,round((cantitate*pret),2) as 'Total',firma 
FROM procesare 
WHERE 
  tip_actiune='intrare' 
AND
  data_curenta >= '2007-04-03' 
and 
  data_curenta <= '2007-05-05'  
ORDER by cod_produs asc;
 

i want to do something like that only with months :

data_curenta like '%2007-04%' and data_curenta like '%2007-06%'


i don't know how to do it .Pls help

[luckilian]

try
where data_curenta >= '2007-04-01' and data_curenta <= '2007-06-31'
:P

[pradeep kaltari]

Hi there i have a problem with on mysql query ..
i want to extract all the data from mysql table within 2 months ..

SELECT data_curenta,cod_produs,denumire,cantitate,pret,ro und((cantitate*pret),2) as 'Total',firma FROM procesare WHERE tip_actiune='intrare' AND
data_curenta >= '2007-04-03' and data_curenta <= '2007-05-05' ORDER by cod_produs asc;"

i want to do something like that only with months :

data_curenta like '%2007-04%' and data_curenta like '%2007-06%'


i don't know how to do it .Pls help

Hi,
Try something like this:

SELECT * 
FROM procesare 
WHERE tip_actiune='intrare' AND
data_curenta >= ( SELECT MIN(data_curenta) FROM procesare WHERE data_curenta LIKE '2007-04%') AND data_curenta < ( SELECT MIN(data_cureta) FROM procesare WHERE data_curenta LIKE '2007-06%' ) ORDER by cod_produs asc
 

I hope this solves your problem.

Regards,
Pradeep

[luckilian]

tnx .. it work . tnx a lot