Posted by Erwin Moller on 11/18/65 11:42

no.mail.pls wrote:

> Hiya,
>
> How do i retreive fields with similar values from 2 tables?
>
> I tried to use
> (1) "SELECT * FROM $table1 as o , $table2 as p WHERE o.name like
> '%p.name%'";
> but it retrieves nothing at all.
>
> (2) "SELECT * FROM $table1 as o , $table2 as p WHERE o.name like p.name";
> will retrieve exact matches only, but this is not what i want.
>
> (3) SELECT * FROM $table1 as o , $table2 as p WHERE o.name LIKE
> CONCAT('%', p.name, '%');
> will retrieve exact matches only.
>
> Any advice will be appreciated.

Hi,

I never saw LIKE used in that way ever before, and am unsure if that is
possible.
I only used/saw LIKE with a literal string, not a dynamic construct, like
yours, joined on another table.
I would advise you to dive into the documentation for your version of mysql,
to first check if it is allowed anyway.

If it is not allowed: solve the problem programmatically. Get the table into
your scriptingenvironment and solve the join in there.

But once again: I could be completely wrong, and maybe it IS possible in
mysql.

Regards,
Erwin Moller

>
> PostScript: i posted the above in mysql groups, but problem remains, so am
> trying my luck here.
>
> TIA

[Back to original message]