Re: SQL prob
| From: | Micah Stevens | Date: | Mon, 31 Jan 2005 02:45:06 +0000 |
| Subject: | Re: SQL prob | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-38397@lists.php.net to get a copy of this message | ||
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@elstudion.com _
> winamp >> Not playing anything right now...