MySQL Forums
Forum List  »  General

How to update string in mysql
Posted by: tien nguyen
Date: January 05, 2016 09:11PM

Hi everybody. I have a string be save in mysql database. When i var_dump it like this.
string(280) "{"2016-01-07":{"available":"3","bind":"0","price":"1000000","promo":"0","status":"available"},"2016-01-08":{"available":"3","bind":"0","price":"1000000","promo":"0","status":"available"},"2016-01-09":{"available":"3","bind":"0","price":"1000000","promo":"0","status":"available"}}"
I want to update "available":"3" become "available":"2"
Note: number "3" is not a constants. It is a variables when I query from database.
Thanks you.
Sorry my english so bad.

Options: ReplyQuote


Subject
Written By
Posted
How to update string in mysql
January 05, 2016 09:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.