Re: MySQL, avanceret distinct? (i hvert fald for mig)

Article View: dk.edb.database

Article #15190

#15190

From: Jonas Delfs
Date: Sat, 07 Jul 2001 14:07

19 lines
1764 bytes

"Niels Andersen" <niels-usenet@myplace.dk> skrev i en meddelelse
news:lpo17.5032$c63.500836@news000.worldonline.dk...

> Jeg har en tabel hvor n�glen er en streng. Faktisk er det to (i fremtiden
> m�ske flere) ord, sammensat med en underscore (_), fx. s�dan her:
> "key1_key2".
> Det fungerer ganske glimrende, men det er vist lidt uheldigt
> database-design. Jeg har nu i hvert fald det problem, at jeg skal have en
> liste over f�rste del.

Pseudokode:
SELECT DISTINCT SUBSTRING(feltnavn, LOCATE('_', feltnavn), LOCATE('_',
feltnavn, LOCATE('_', feltnavn))) AS key1 FROM tabel

M�ske?

--
Mvh. Jonas Delfs, http://delfs.dk
e72bd3e51a7937c87d28b85d677a97b2

Technical Details

Message-ID: <9i74tk$5qc$1@sunsite.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!sunsite.dk!not-for-mail

References: <lpo17.5032$c63.500836@news000.worldonline.dk>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,dbc86c5093ce8294
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-07 07:05:36 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!sunsite.dk!not-for-mail
From: "Jonas Delfs" <jonas@nospam.delfs.dk>
Newsgroups: dk.edb.database
Subject: Re: MySQL, avanceret distinct? (i hvert fald for mig)
Date: Sat, 7 Jul 2001 16:07:46 +0200
Organization: SunSITE.dk - Supporting Opensource Software
Lines: 21
Sender: jonas@131.165.143.165
Message-ID: <9i74tk$5qc$1@sunsite.dk>
References: <lpo17.5032$c63.500836@news000.worldonline.dk>
NNTP-Posting-Host: 131.165.143.165
X-Trace: sunsite.dk 994514677 5964 131.165.143.165 (7 Jul 2001 14:04:37 GMT)
X-Complaints-To: news@sunsite.dk
NNTP-Posting-Date: Sat, 7 Jul 2001 14:04:37 +0000 (UTC)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-Authenticated: jonas@delfs.dk

Reply to Parent Message