Posted by J.O. Aho on 12/04/05 16:17

Diego wrote:
> Hello.
> My name is Diego.
> At first, let me say: * I'm trying write in english. =) *
>
>
> I'm trying to learn php+mysql, but I am stuck in a sentence..
>
> I've :
>
> idBirth - autonumeric
> date - date (YYYY-MM-DD)
> timestart - time (00:00:00)
> timeend - time (00:00:00)
>
> idBirth is that I use to relation with another tables.
>
> My trouble is: I don't know how to select a value between 2 dates. (i.e.
> 2005-12-04 and 2005-1-15).

Should be something like (assuming that date column is of the type DATE):
SELECT * FROM <table_name> WHERE date <= '2005-12-04' AND date >= '2005-1-15'


> ps: does anybody know a mysql spanish news?

Not really, but if I haven't mixed the languages, I think you can find things
in Spanish at http://www.mysql-hispano.org/


//Aho

[Back to original message]