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;
};
};
};
|---------------------------------------------------------------------------
--------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------
----------------------------------------------------------+
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
