Re: SQL vraagje

Article View: be.comp.programming

Article #13691

Back to be.comp.programming Previous Next

#13691

From: Franky Claeys
Date: Sat, 09 Jun 2001 11:38

33 lines
1976 bytes

yes yes,

deze doet het helemaal!

bedankt!

Frank


"Rene Pijlman" <reageer.in.de.nieuwsgroep@onzin-adres.nl> schreef in bericht
news:pas3its3flao6ap4ak5hv6kccokt7affkv@4ax.com...
> "Franky Claeys" <franky.claeys@vt4.net> schreef:
> >Ik wil nu enkel alle gegevens uit de records 23 maart 1998, 23 maart
1999,
> >23 maart 2000 en 23 maart 2001.
>
> Probeer het eens zo:
>
> SELECT *
> FROM tableX
> WHERE date = '1998-03-23' OR
>       date = '1999-03-23' OR
>               date = ...
>
> Ik weet even niet uit mijn hoofd of '1998-03-23' de juiste manier is
> om een datum te noteren in MySQL.
>
> --
> Vriendelijke groet,
> Ren� Pijlman <rpijlman@spamcop.net>
>
> Wat wil jij leren?
> http://www.leren.nl/

Technical Details

Message-ID: <9ft1r8$1dp$1@mykenos.hogent.be>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!t-online.de!news-ge.switch.ch!naxos.belnet.be!news.belnet.be!mykenos.hogent.be!not-for-mail

References: <9fsr7v$svp$1@mykenos.hogent.be> <pas3its3flao6ap4ak5hv6kccokt7affkv@4ax.com>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII
X-Google-Thread: 107324,64d771637e141bf4
X-Google-Attributes: gid107324,public
X-Google-Thread: fcea4,64d771637e141bf4
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2001-06-09 04:40:02 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!t-online.de!news-ge.switch.ch!naxos.belnet.be!news.belnet.be!mykenos.hogent.be!not-for-mail
From: "Franky Claeys" <franky.claeys@vt4.net>
Newsgroups: be.comp.programming,nl.comp.programmeren
Subject: Re: SQL vraagje
Date: Sat, 9 Jun 2001 13:38:08 +0200
Organization: Hogeschool Gent
Lines: 35
Sender: 963017fc@uu212-190-1-182.unknown.uunet.be
Message-ID: <9ft1r8$1dp$1@mykenos.hogent.be>
References: <9fsr7v$svp$1@mykenos.hogent.be> <pas3its3flao6ap4ak5hv6kccokt7affkv@4ax.com>
NNTP-Posting-Host: uu212-190-1-182.unknown.uunet.be
X-Trace: mykenos.hogent.be 992086696 1465 212.190.1.182 (9 Jun 2001 11:38:16 GMT)
X-Complaints-To: newsmaster@hogent.be
NNTP-Posting-Date: 9 Jun 2001 11:38:16 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400

Reply to Parent Message