MySQL Forums
Forum List  »  Connector/Node.js

Comment inside Table
Posted by: Mohamed Abdelwahed
Date: March 16, 2016 08:27AM

Hi All,
I am new to Mysql and i have an issue with a table contain data like this

{"1":{"comment":"test 1","rating_id":1},"2":{"comment":"test 2","rating_id":5},"3":{"comment":"test 3","rating_id":5},"4":{"comment":"test 5","rating_id":4},"5":{"comment":"test8","rating_id":5}}
The user wrote test 1 , test 2 ,etc
i want to select just what the user wrote i do not want to seethe word comment in my report .
How can i do this ?

Options: ReplyQuote

Written By
Comment inside Table
March 16, 2016 08:27AM

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.