yep, that's the problem. But MySQL wouldn't do anything else, just a bit
faster because there are no queries to "compile". The only problem is, i
don't know how to split this field into single values. If this would be
possible, you could fill another table3 w/ these values enclosed by % % as
patterns and do this:
select row from table2,table3 where fields-m like table3.patterns;
This should work, regards
Jan
----- Original Message -----
From: "Javier" <javier@stripped>
To: "Jan Peuker" <jan.peuker@stripped>
Sent: Monday, April 29, 2002 7:48 PM
Subject: Re: What is the best way to do this
> Thanks, this should work, but I'm worry about the speed, because, both
> tables are very big. Maybe exists some possibility to do this using
> temporary tables and mysql variables, what do you think?
>
> Thanks
>
> Javier
>
> ----- Original Message -----
> From: Jan Peuker <jan.peuker@stripped>
> To: Javier <javier@stripped>
> Sent: Monday, April 29, 2002 6:23 PM
> Subject: Re: What is the best way to do this
>
>
> > My (dumy-newbie) opinion is, that this task would be too hard for mysql.
> > Better do this in your program, e.g. first do a select on table1 and
> create
> > an array out of the results(split the line and trim the values), then do
a
> > while/for with "select row from table2 where field-m like
'%arrayfield%'"
> > (for sure, replace arrayfield).
> > regards,
> >
> > Jan
> >
> > ----- Original Message -----
> > From: "Javier" <javier@stripped>
> > To: <mysql@stripped>
> > Sent: Monday, April 29, 2002 6:52 PM
> > Subject: What is the best way to do this
> >
> >
> > >
> > > Hi everybody,
> > >
> > > I need do the following:
> > >
> > > I have two MySQL tables,
> > >
> > > Table1
> > > .
> > > .
> > > field-n
> > > .
> > > .
> > >
> > > Table2
> > > .
> > > .
> > > field-m
> > > .
> > > .
> > >
> > > <field-n> and <field-m> are both varchar(100) containing
> words
> separated
> > by
> > > space. I need to find out if any of the words in <field-n> also
> are
in
> > > <field-m>.
> > >
> > > Is it possible to do that? What is the best way for it?
> > >
> > > Thanks
> > >
> > > Javier Diaz
> > > IT Developer
> > >
> > >
> > >
> > > - Scanned for all known viruses by Messagelabs --
> > >
> > > ---------------------------------------------------------------------
> > > 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 <mysql-thread107490@stripped>
> > > To unsubscribe, e-mail
> > <mysql-unsubscribe-jan.peuker=janus-graphics.de@stripped>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> >
> >
> > - Scanned for all known viruses by Messagelabs --
>
>
> - Scanned for all known viruses by Messagelabs --
