Retrieve fields with similar values from 2 tables?

[no.mail.pls]

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

[Jerry Stuckle]

no.mail.pls wrote:

"Jerry Stuckle" <js*******@attg lobal.net> wrote in message
news:Qd******** *************** *******@comcast .com...

no.mail.pls wrote:

"Jerry Stuckle" <js*******@attg lobal.net> wrote in message
news:FO***** *************** @comcast.com...
no.mail.p ls 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.da tabases.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.

Perhaps it is more accurate to say that it includes, as well as excludes,
x-posting. Sell not the devil short.

cheers

Only in your book does it include multi-posting to multiple newsgroups.

If you want the help, follow the conventions. Otherwise soon you won't
be able to get any responses to any of your questions.

Remember - we're all volunteers here. None of us are being paid to help
you. And we don't have to.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[no.mail.pls]

"Jerry Stuckle" <js*******@attg lobal.net> wrote in message
news:E5******** ************@co mcast.com...

no.mail.pls wrote:

"Jerry Stuckle" <js*******@attg lobal.net> wrote in message
news:Qd******** *************** *******@comcast .com...

no.mail.pl s wrote:

"Jerry Stuckle" <js*******@attg lobal.net> wrote in message
news:FO**** *************** *@comcast.com.. .
>no.mail.pl s 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.
>>
>>PostScrip t: 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.d atabases.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.

Perhaps it is more accurate to say that it includes, as well as excludes,
x-posting. Sell not the devil short.

cheers

Only in your book does it include multi-posting to multiple newsgroups.

If you want the help, follow the conventions. Otherwise soon you won't be
able to get any responses to any of your questions.

Remember - we're all volunteers here. None of us are being paid to help
you. And we don't have to.

Appreciate if you can show me the convention that multi-posting is not
allowed, bearing in mind that i first asked in one newsgroup, and failing to
get a solution, i asked in another.

If what you claimed as convention is true, then i should never ask the same
question again in another newsgroup, even though there is no solution from
the first group i posted in.

And if x-posting is allowed, then i should post a question in all relevant
newsgroups simultaneously.

Is the above true?

cheers

[Erwin Moller]

no.mail.pls wrote:

"Jerry Stuckle" <js*******@attg lobal.net> wrote in message
news:E5******** ************@co mcast.com...

no.mail.pls wrote:

"Jerry Stuckle" <js*******@attg lobal.net> wrote in message
news:Qd******** *************** *******@comcast .com...

no.mail.p ls wrote:

>"Jerry Stuckle" <js*******@attg lobal.net> wrote in message
>news:FO*** *************** **@comcast.com. ..
>
>
>>no.mail.p ls 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.
>>>
>>>PostScri pt: 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.
>
>Tiptoein g 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.

Perhaps it is more accurate to say that it includes, as well as
excludes, x-posting. Sell not the devil short.

cheers

Only in your book does it include multi-posting to multiple newsgroups.

If you want the help, follow the conventions. Otherwise soon you won't
be able to get any responses to any of your questions.

Remember - we're all volunteers here. None of us are being paid to help
you. And we don't have to.

Appreciate if you can show me the convention that multi-posting is not
allowed, bearing in mind that i first asked in one newsgroup, and failing
to get a solution, i asked in another.

If what you claimed as convention is true, then i should never ask the
same question again in another newsgroup, even though there is no solution
from the first group i posted in.

And if x-posting is allowed, then i should post a question in all relevant
newsgroups simultaneously.

Is the above true?

cheers

Hi,

Allow me to drop in here.
Jerry was only warning you that multiposting can work against you.
If I see the same question in more newsgroups I follow, I almost never
answer because I don't know where to answer, and am unsure if the poster is
checking them all. Even if I perfectly well know how to help.

So you can ask for conventions and such, but that won't help. You can find
1000 opinionson how to behave on usenet.

Bottomline is that many do not appreciate multipost, and in the end it will
work against you.

(Just ment as a kind word of advise)
Best of luck,
Erwin Moller

[Jerry Stuckle]

no.mail.pls wrote:

Appreciate if you can show me the convention that multi-posting is not
allowed, bearing in mind that i first asked in one newsgroup, and failing to
get a solution, i asked in another.

If what you claimed as convention is true, then i should never ask the same
question again in another newsgroup, even though there is no solution from
the first group i posted in.

And if x-posting is allowed, then i should post a question in all relevant
newsgroups simultaneously.

Is the above true?

cheers

You should pick and choose the most likely group(s) where your question could be
asked. Then cross-post to those groups. Typically you should post to at most
three or four groups; if you need to post to more generally your question is too
broad (you haven't identified the problem yet) or you're posting to
inappropriate groups.

Once you have posted - wait at least 24 to 48 hours for a response. If you
haven't gotten a response by that time, chances are your question was not clear
or was not appropriate to those newsgroups. Seldom have I ever seen a message
go longer than that (at least in busy newsgroups) not be responded to in that time.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===