Christian Andersson writes:
> I'm not sure if this is a good idea or bad, but I have one idea about the
> Limit funtionallity
>
> (which incidently might solve my order by, group by problem :-)
>
> I KNOW that it is NOT possible to do this now, so no RTFM :-) this is just
> an idea..
>
> LIMIT is as I understand it something that is mysql specific (I know
> informix has something similiar but they write it some other way)
>
> so adding functionallity here would not break any existing rule
>
> anyway, my idea is this..
>
> LIMIT columnname 1
>
> would return only 1 row for each unique value in the columnname
>
> LIMIT columnname1,columnname2 2
>
> would return max 2 rows for each unique combination of values in the
> columnname1+columnname2
>
> or perheps have a different name for this..
>
>
> Another way to solve my problem would be if there was some sort of
> FIRST_IN_SET functionallity that I could use on the where clause
> select * from articles where language = FIRST_IN_SET('en,sv,no')
>
> remember these are just ideas, that might be scratched or remembered
> If I know how to do it, I would perheps implement this myself in my own
> version of mysql, but I'm not THAT good .-)
>
> /Christian Andersson
>
>
Hi!
Just a small note. LIMIT is defined in ANSI SQL standard.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
