SQL prob
| From: | Bobo Wieland | Date: | Sun, 30 Jan 2005 20:51:15 +0000 |
| Subject: | SQL prob | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-38396@lists.php.net to get a copy of this message | ||
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@elstudion.com _ winamp >> Not playing anything right now...