|
|
Posted by no.mail.pls on 03/24/06 07:16
"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:E56dnaNQVYJdJr3Z4p2dnA@comcast.com...
> no.mail.pls wrote:
>> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
>> news:Qd6dnT4CVp__d4LZnZ2dnUVZ_vidnZ2d@comcast.com...
>>
>>>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.
>>
>> 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
Navigation:
[Reply to this message]
|