Re: How to update string in mysql

[Peter Brawley]

The string has double quotes but no single quotes, so surround with the latter:

update tbl set col = replace( col, '"available":"3"', '"available":"2"' );