% in < >?

[Anon]

I know what I am typing below won't work, but I'm hoping someone understands well enough what I'm trying to do to help me figure out how to implement it. (MySQL, btw)

I have a field, date, that has YYYY-MM-DD in it. I want to have a form where you put in, say, 05 and 15 and it then looks for matches on DD for those days and between. Sorta like -

select id,name from db where date >= "%05" AND date <= "%15";

I know this doesn't work. I tried it. But I'm hoping someone out there can set me on the right path. :oP

[Anon]

Store dd in seperate field (just strip out those chars on insertion or upon taking it out. Then just run =>$num1 and =<$num2

Alex Darke wrote:

I know what I am typing below won't work, but I'm hoping someone understands well enough what I'm trying to do to help me figure out how to implement it. (MySQL, btw)

I have a field, date, that has YYYY-MM-DD in it. I want to have a form where you put in, say, 05 and 15 and it then looks for matches on DD for those days and between. Sorta like -

select id,name from db where date >= "%05" AND date <= "%15";

I know this doesn't work. I tried it. But I'm hoping someone out there can set me on the right path. :oP

[Anon]

"Store dd in seperate field (just strip out those chars on insertion or upon taking it out. Then just run =>$num1 and =<$num2 "

Well, if I knew how to do that, I wouldn't be seeking help. grins

Can you give me an example? I'm pretty handy on figuring stuff out from example code, and I have to do the truncation on the select, not the insert, because other stuff requires the full date to be in that field.

all help appreciated

[Anon]

use the SUBSTR() function
i.e.
SELECT SUBSTR(DATE, 5, 2) FROM tablename;
i THINK that will give you 2 characters starting at position 5, although you have to look up that function but that should do it
so then you can do:
SELECT SUBSTR(DATE, 5, 2) AS dd FROM tablename
WHERE dd <= 15 AND dd >= 1;

good luck

justin

[Anon]

A friend also pointed out to me

select id, name, whatever from table where DAYOFMONTH(date) > 5 and DAYOFMONTH(date) < 15;

which works as well. :o)

Thanks for your help everyone.