I use codeigniter. i have following values as json_encode in database row, for example i want delete value “3” in row 1 and values “14” & “5” from table “ex_table” in database.
Row 1:
id=1
[{
"hotel_id": ["3"]
}, {
"hotel_id": ["2"]
}, {
"hotel_id": ["1"]
}]
Row 2:
id=2
[{
"hotel_id": ["14"]
}, {
"hotel_id": ["5"]
}, {
"hotel_id": ["4"]
}, {
"hotel_id": ["3"]
}, {
"hotel_id": ["2"]
}, {
"hotel_id": ["1"]
}]
what do i do?
