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

Article View: dk.edb.database

Article #15185

#15185

From: Niels Andersen
Date: Fri, 06 Jul 2001 19:33

13 lines
1506 bytes

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. Alts�, hvis man fjerner alt fra og med f�rste
underscore, og s� skal jeg have en liste uden dubletter. Kan det overhovedet
lade sig g�re?

--
Mvh.

Niels Andersen

Technical Details

Message-ID: <lpo17.5032$c63.500836@news000.worldonline.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!news000.worldonline.dk.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,dbc86c5093ce8294,start
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-06 12:34:42 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!news000.worldonline.dk.POSTED!not-for-mail
From: "Niels Andersen" <niels-usenet@myplace.dk>
Newsgroups: dk.edb.database
Subject: MySQL, avanceret distinct? (i hvert fald for mig)
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2462.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2462.0000
Message-ID: <lpo17.5032$c63.500836@news000.worldonline.dk>
Date: Fri, 6 Jul 2001 21:33:43 +0200
NNTP-Posting-Host: 213.237.14.186
X-Complaints-To: news-abuse@wol.dk
X-Trace: news000.worldonline.dk 994448081 213.237.14.186 (Fri, 06 Jul 2001 21:34:41 MET DST)
NNTP-Posting-Date: Fri, 06 Jul 2001 21:34:41 MET DST
Organization: Customer of Tiscali A/S (World Online)