Posted by Jerry Stuckle on 03/21/06 13:56

no.mail.pls wrote:
> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
> news:FOqdnaQ40Ly9L4fZRVn-rw@comcast.com...
>
>>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.
>>>
>>>PostScript: i posted the above in mysql groups, but problem remains, so
>>>am trying my luck here.
>>>
>>>TIA
>>
>>You've also asked this in (at least) comp.databases.mysql and
>>alt.comp.databases.mysql (where is is much more appropriate).
>>
>>And please learn how to cross-post.
>
>
> Pethaps to x-post or not is a choice between the devil and the deep blue
> sea, even though not all of us believe in devils, and some of us love the
> deep blue sea.
>
> Tiptoeing gently among the mines in Usenet can be a tricky bizness.
>
> cheers
>
>

And people who want answers should follow usenet conventions - which
includes cross-posting instead of multi-posting.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]