List:General Discussion« Previous MessageNext Message »
From:YL Date:September 2 2005 8:18pm
Subject:2 query questions
View as plain text  
I've 2 basic questions. thanks for responses:

(1) Suppose i have a table with a varchar colum named options which stores
option id's in the form
     "(id1, id2, ...., idk)", where id1,... are string representations of
positive integers. Given an integer i,
     I want to fetch all ID's for the records in the table whoes 'options'
value when interprets as an array,
     contains integer i. What the query looks like?

(2) when using mysql command to query a value of type text, the displayed
value always surrounded by lots
'-'s. My question is: How to get rid of those extras? (The following is a
tail of display result:)
                          template = {
               b5 = resources/articles/_backups/subIndex_b5.template;
               gb = resources/articles/_backups/subIndex_gb.template;
           };
       };
   };

|---------------------------------------------------------------------------
--------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------
----------------------------------------------------------+

Thread
Trouble with revoke allScott Haneda2 Sep
  • Re: Trouble with revoke allGleb Paharenko2 Sep
    • Re: Trouble with revoke allScott Haneda2 Sep
      • Re: Trouble with revoke allMichael Stassen2 Sep
        • Re: Trouble with revoke allScott Haneda3 Sep
          • Re: Trouble with revoke allMichael Stassen3 Sep
            • Re: Trouble with revoke allScott Haneda3 Sep
              • Multiple query execution (probably OT)Alvaro Cobo3 Sep
                • Re: Multiple query execution (probably OT)Gleb Paharenko3 Sep
                • How to migrate from V4.0.23 to V5?Siegfried Heintze4 Sep
                  • Re: How to migrate from V4.0.23 to V5?Gleb Paharenko5 Sep
      • Re: Trouble with revoke allGleb Paharenko2 Sep
        • Re: Trouble with revoke allScott Haneda3 Sep
    • 2 query questionsYL2 Sep
      • Re: 2 query questionsJason Pyeron2 Sep
      • Re: 2 query questionsSGreen2 Sep
        • string->array question. ( 2 query questions)YL3 Sep
          • Re: string->array question. ( 2 query questions)Peter Brawley3 Sep
        • Re: string->array question. ( 2 query questions)YL3 Sep
          • Re: string->array question. ( 2 query questions)Peter Brawley3 Sep