List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:September 21 2010 5:37pm
Subject:RE: SELECT WHERE IN help
View as plain text  
>-----Original Message-----
>From: Tompkins Neil [mailto:neil.tompkins@stripped]
>Sent: Tuesday, September 21, 2010 11:48 AM
>To: Johan De Meersman
>Cc: [MySQL]
>Subject: Re: SELECT WHERE IN help
>
>Thanks for the reply.  The search of  (3,4,5,6,7,3)  is pulling data from a
>table.  I think in this case I need to change my design .
>
[JS] You can accomplish your goal by using a sub-select to create a "table" 
that has 3 in it twice, and then JOIN it to the original table.

As for why you would want to do this, that's another story. It sounds like you 
went down the wrong road.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@stripped
Web site: www.the-infoshop.com




>On Tue, Sep 21, 2010 at 4:46 PM, Johan De Meersman <vegivamp@stripped>wrote:
>
>> I don't think that'll work, no. Why would you want to return duplicate data
>> ? The whole point of an RDBMS is to *avoid* duplicate data :-)
>>
>>
>> On Tue, Sep 21, 2010 at 5:44 PM, Tompkins Neil <
>> neil.tompkins@stripped> wrote:
>>
>>> Thanks for the quick reply.  Basically in (3,4,5,6,7,3) the record_id of
>>> 3 only exists once in the table my_table.  However, because 3 exists
>>> twice within  (3,4,5,6,7,3), I want it to return two records for
>>> record_id 3.  Is it possible ?
>>>
>>> Cheers
>>> Neil
>>>
>>>
>>> On Tue, Sep 21, 2010 at 4:40 PM, Johan De Meersman
><vegivamp@stripped>wrote:
>>>
>>>> If there are two, you will return two.
>>>>
>>>>
>>>> On Tue, Sep 21, 2010 at 5:33 PM, Tompkins Neil <
>>>> neil.tompkins@stripped> wrote:
>>>>
>>>>> Hi
>>>>>
>>>>> With a SELECT * FROM my_table WHERE record_id IN (3,4,5,6,7,3), how
> can
>>>>> I
>>>>> return two records for the record_id 3 ?  Is it possible ?
>>>>>
>>>>> Cheers
>>>>> Neil
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Bier met grenadyn
>>>> Is als mosterd by den wyn
>>>> Sy die't drinkt, is eene kwezel
>>>> Hy die't drinkt, is ras een ezel
>>>>
>>>
>>>
>>
>>
>> --
>> Bier met grenadyn
>> Is als mosterd by den wyn
>> Sy die't drinkt, is eene kwezel
>> Hy die't drinkt, is ras een ezel
>>



Thread
SELECT WHERE IN helpTompkins Neil21 Sep
  • Re: SELECT WHERE IN helpJohan De Meersman21 Sep
    • Re: SELECT WHERE IN helpTompkins Neil21 Sep
      • Re: SELECT WHERE IN helpJohan De Meersman21 Sep
        • Re: SELECT WHERE IN helpTompkins Neil21 Sep
          • RE: SELECT WHERE IN helpJerry Schwartz21 Sep
      • Re: SELECT WHERE IN helpMark Goodge21 Sep
  • Re: SELECT WHERE IN helpJoerg Bruehe21 Sep