between con like

[bon3]

Iniciado por leonardo_josue

Código MySQL:

mysql> create table fechas (fecha datetime);
Query OK, 0 rows affected (0.31 sec)
 
mysql> insert into fechas values ('2011-08-31'), ('2011-09-01 00:00:01'),
    -> ('2011-11-30 23:59:59'),('2011-12-31 23:59:59'),('2012-01-01 00:00:01');
Query OK, 5 rows affected (0.08 sec)
Records: 5  Duplicates: 0  Warnings: 0
 
mysql> select * from fechas;
+---------------------+
| fecha               |
+---------------------+
| 2011-08-31 00:00:00 |
| 2011-09-01 00:00:01 |
| 2011-11-30 23:59:59 |
| 2011-12-31 23:59:59 |
| 2012-01-01 00:00:01 |
+---------------------+
5 rows in set (0.07 sec)
 
mysql> select * from fechas where year(fecha) = 2011 and
    -> month(fecha) between 9 and 12;
+---------------------+
| fecha               |
+---------------------+
| 2011-09-01 00:00:01 |
| 2011-11-30 23:59:59 |
| 2011-12-31 23:59:59 |
+---------------------+
3 rows in set (0.07 sec)
 

Excelente muchas gracias Leo me diste otra idea de como hacerlo un saludo y de nuevo gracias :D