mysql using between

[sang]

Sir

My table name ss with the field cur_date data type varchar()

show create table ss;
+-------+-----------------------------------------------------------------------
---------------------------+
| Table | Create Table
|
+-------+-----------------------------------------------------------------------
---------------------------+
| ss | CREATE TABLE `ss` (
`cur_date` varchar(18) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+-----------------------------------------------------------------------
---------------------------+
1 row in set (0.01 sec)

select * from ss;

+-------------+
| cur_date |
+-------------+
| 11-oct-2006 |
| 12-oct-2006 |
| 15-oct-2006 |
| 20-oct-2006 |
+-------------+
4 rows in set (0.03 sec)

In this i want to select the particular dates by using the between & and commands.

my cmd is

select * from ss where cur_date between date_format(str_to_date('11-oct-2006',"%d-%b-%Y"),"%d-%m-%Y") and date_format(str_to_date('15-oct-2006',"%d-%b-%Y"),"%d-%m-%Y");

+-------------+
| cur_date |
+-------------+
| 11-oct-2006 |
| 12-oct-2006 |
+-------------+
2 rows in set (0.00 sec)

but in this i am changing the month that is replace oct to nov but it will also produce the result

that is
select * from ss where cur_date between date_format(str_to_date('11-nov-2006',"%d-%b-%Y"),"%d-%m-%Y") and date_format(str_to_date('15-nov-2006',"%d-%b-%Y
"),"%d-%m-%Y");

the result is also

+-------------+
| cur_date |
+-------------+
| 11-oct-2006 |
| 12-oct-2006 |
+-------------+
2 rows in set (0.00 sec)

how to overcome the problem

pls any one help to me

Thanks & Regards
Sang

[ronverdonk]

Read the Posting Guidelines at the top of the forum page. Especailly the part about showing code between php, code or html tags!!

Until then I will not look at your code or samples, it's a mess!

Ronald :cool: