Thanks, but DISTINCT doesn't work... But I managed to get it to work
anyway by including
"namn_1 NOT LIKE 'H%'"
in the second WHERE-clause...
Micah Stevens wrote:
use DISTINCT?
On Sunday 30 January 2005 12:51 pm, Bobo Wieland wrote:
Anyone that can help me with this one? I want this SQL-statement to
retrive only distinct values from the original table column named (not
the AS stuff)
(
SELECT * , namn_2 AS sec_namn, namn_1 AS one
FROM sortiment
WHERE namn_1 LIKE 'H%'
)
UNION (
SELECT * , UPPER( namn_2 ) AS sec_namn, namn_2 AS one
FROM sortiment
WHERE namn_2 LIKE 'H%'
AND SUBSTRING( namn_2, 1, 1 ) LIKE BINARY 'H'
)
ORDER BY one
LIMIT 0 , 10
this will return, for example, the following row twice where (in the
original table)
namn_1 = "Humulus lupulus"
namn_2 = "Humle"
the two rows are identical except for the "sec_namn" and "one" created
by the query. They are set to:
sec_namn one
HUMLE Humle
Humle Humulus lupulus
_bobo wieland _ dev@xxxxxxxxxxxxx _
winamp >> Not playing anything right now...
--
_bobo wieland _ dev@xxxxxxxxxxxxx _
winamp >> Not playing anything right now...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
