MySQL Forums
Forum List  »  German

Advanced Search
New Topic

Re: where / between
Posted by: Thomas Wiedmann
Date: October 10, 2010 04:29AM

Das erste Filterprädikat in SQL lautet "WHERE" , kommen weitere Prädikate dazu dann geht es mit "AND" weiter. BETWEEN ist da eine kleine Ausnahme, der zu einem BETWEEN immer ein AND gehört.


Also einfach mal so probieren.. 

SELECT * from eib_tele 
 where last_time between '2010-7-6%' and '2010-7-14%' 
   and ga1=6145;

Grüße
Thomas

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
where / between
15085
Götz Hagmann
October 09, 2010 09:21AM
Re: where / between
3852
Thomas Wiedmann
October 10, 2010 04:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.