I wrote:
> # create test tables
> create table msg_main (mid int not null,name char(16),primary key(mid));
> create table msg_lang (mid int not null,lang char(2) not null,message
> text,primary key(mid,lang));
mid is a bad choice for column names, because it is a function... it is
however not an
* DL Neil
[About Christian's problem with joining language specific info.]
> MIN( FIELD( language, 'no', 'en', 'fr', 'sv' ) )
>
Hi,
I have a similar problem, and have found a workaround that may be useful for
you, Christian. Use an extra left join to find the records you don't want...
# cr
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
