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
Robot rubbish: MIN, FIELD, MySQL, SQL
> Christian,
>
> ...
> > > 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')
>
> =I "languag
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
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
