hello;
I have a table, the_table:
_____________________________
|column_1 |
|---------------------------------------|
|("index_1"=>"doo-hicky-A") |
|________________________|
that is a php associative array within a field;
ofcourse I can mysql:SELECT * FROM THE_TABLE and return it to the php script, do whatever I need to do inside the array with php, and then mysql:UPDATE THE_TABLE ... ;
however what I would like to do is have a table, ideal_table:
_______________________
|column_1 |
|-------------------------------|
|a mysql formatted array |
|______________________|
such that I can mysql:UPDATE IDEAL_TABLE SET COLUMN_1.INDEX_1 = 'DOO-HICKY-B' WHERE COLUMN_1.INDEX_1='DOO-HICKY-A'
any thoughts
thanks
Shannon Burnett
an array inside a mysql table
Moderator: General Moderators
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
afaik, mysql doesn't support what you are talking about.
you could instead, have 2 columns and then
you could instead, have 2 columns and then
Code: Select all
UPDATE SET column = 'thing2' WHERE column1 = 'index_1', column = 'thing1'