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
---------------------------------------------------------------------
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
