|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
10/02/2008, 15h18
|
#1 |
Messages: n/a
Hébergeur: |
with DISTINCT keyword
Hi,
I'm trying to select only unique values from 3 columns (filter1,filter2,filter3) and return them in their original columns. I've got this so far but the UNION simply lists all results under the filter1 column. How can I correct this please? SELECT DISTINCT filter1 AS filter1 FROM `home_index` UNION SELECT DISTINCT filter2 AS filter2 FROM `home_index` UNION SELECT DISTINCT filter3 AS filter3 FROM `home_index` Thanks for any ! Ciarán |
|
|
10/02/2008, 15h41
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: with DISTINCT keyword
On Sun, 10 Feb 2008 06:18:44 -0800, Ciaran wrote:
> Hi, > I'm trying to select only unique values from 3 columns > (filter1,filter2,filter3) and return them in their original columns. > I've got this so far but the UNION simply lists all results under the > filter1 column. How can I correct this please? > > SELECT DISTINCT filter1 AS filter1 > FROM `home_index` > UNION > SELECT DISTINCT filter2 AS filter2 > FROM `home_index` > UNION > SELECT DISTINCT filter3 AS filter3 > FROM `home_index` > > Thanks for any ! > Ciarán Are you looking for this? SELECT DISTINCT filter1 AS filter1, '' AS filter2, '' AS filter3 FROM home_index UNION SELECT DISTINCT '' AS filter1, filter2 AS filter2, '' AS filter3 FROM home_index UNION SELECT DISTINCT '' AS filter1, '' AS filter2, filter3 AS filter3 FROM home_index -- PleegWat Remove caps to reply |
|
|
|
10/02/2008, 16h06
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: with DISTINCT keyword
On Feb 10, 2:41 pm, PleegWat
<pleegwat.REM...@CAPS.leegwater-68.nl.INVALID> wrote: > On Sun, 10 Feb 2008 06:18:44 -0800, Ciaran wrote: > > Hi, > > I'm trying to select only unique values from 3 columns > > (filter1,filter2,filter3) and return them in their original columns. > > I've got this so far but the UNION simply lists all results under the > > filter1 column. How can I correct this please? > > > SELECT DISTINCT filter1 AS filter1 > > FROM `home_index` > > UNION > > SELECT DISTINCT filter2 AS filter2 > > FROM `home_index` > > UNION > > SELECT DISTINCT filter3 AS filter3 > > FROM `home_index` > > > Thanks for any ! > > Ciarán > > Are you looking for this? > > SELECT DISTINCT filter1 AS filter1, '' AS filter2, '' AS filter3 > FROM home_index > UNION > SELECT DISTINCT '' AS filter1, filter2 AS filter2, '' AS filter3 > FROM home_index > UNION > SELECT DISTINCT '' AS filter1, '' AS filter2, filter3 AS filter3 > FROM home_index > > -- > PleegWat > Remove caps to reply Yes, Thanks PleegWat - That will do nicely. It produces empty fields but I can just filter them out with php. Thanks for the ! Ciarán |
|
|
|
11/02/2008, 00h16
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: with DISTINCT keyword
PleegWat wrote:
> On Sun, 10 Feb 2008 06:18:44 -0800, Ciaran wrote: > >> Hi, >> I'm trying to select only unique values from 3 columns >> (filter1,filter2,filter3) and return them in their original columns. >> I've got this so far but the UNION simply lists all results under the >> filter1 column. How can I correct this please? >> >> SELECT DISTINCT filter1 AS filter1 >> FROM `home_index` >> UNION >> SELECT DISTINCT filter2 AS filter2 >> FROM `home_index` >> UNION >> SELECT DISTINCT filter3 AS filter3 >> FROM `home_index` >> >> Thanks for any ! >> Ciarán > > Are you looking for this? > > SELECT DISTINCT filter1 AS filter1, '' AS filter2, '' AS filter3 > FROM home_index > UNION > SELECT DISTINCT '' AS filter1, filter2 AS filter2, '' AS filter3 > FROM home_index > UNION > SELECT DISTINCT '' AS filter1, '' AS filter2, filter3 AS filter3 > FROM home_index A "UNION" implies DISTINCT, so the DISTINCTs should not be required. |
|
|
|
11/02/2008, 17h36
|
#5 |
|
Messages: n/a
Hébergeur: |
Re: with DISTINCT keyword
On Sun, 10 Feb 2008 07:06:40 -0800, Ciaran wrote:
> On Feb 10, 2:41 pm, PleegWat > <pleegwat.REM...@CAPS.leegwater-68.nl.INVALID> wrote: >> On Sun, 10 Feb 2008 06:18:44 -0800, Ciaran wrote: >> > Hi, >> > I'm trying to select only unique values from 3 columns >> > (filter1,filter2,filter3) and return them in their original columns. >> > I've got this so far but the UNION simply lists all results under the >> > filter1 column. How can I correct this please? >> >> > SELECT DISTINCT filter1 AS filter1 >> > FROM `home_index` >> > UNION >> > SELECT DISTINCT filter2 AS filter2 >> > FROM `home_index` >> > UNION >> > SELECT DISTINCT filter3 AS filter3 >> > FROM `home_index` >> >> > Thanks for any ! >> > Ciarán >> >> Are you looking for this? >> >> SELECT DISTINCT filter1 AS filter1, '' AS filter2, '' AS filter3 FROM >> home_index >> UNION >> SELECT DISTINCT '' AS filter1, filter2 AS filter2, '' AS filter3 FROM >> home_index >> UNION >> SELECT DISTINCT '' AS filter1, '' AS filter2, filter3 AS filter3 FROM >> home_index >> >> -- >> PleegWat >> Remove caps to reply > > > Yes, Thanks PleegWat - That will do nicely. It produces empty fields but > I can just filter them out with php. Thanks for the ! > Ciarán The field names will be the same for all rows. That's how it's designed and there's no getting around that. If you prefer, you can use NULL instead of '', but that won't matter much for the php side. -- PleegWat Remove caps to reply |
|
|
 |
| Outils de la discussion | |
|
|
