Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • any database in particular ? Commented Sep 17, 2021 at 9:15
  • Hello @user2210516, Can you clarify your question? First you speak of name, firstname and communication as columns of your table. But in the next part of the question you have other properties in you json. Please edit your question more specificly Commented Sep 17, 2021 at 9:15
  • This is not really suitable for SQL. You might want to consider a redesign such that the database fits at least NF1 (no different information packed into the same column). Commented Sep 17, 2021 at 9:17
  • @RonaldHaan Sorry if i was unclear. The json is inside the Communication Column. And i only want mobilephone number from that string inside and make a new select with the mobile number instead of the Communication column. Commented Sep 17, 2021 at 9:19