0

Hey Stack overflow so I have a JSON object in my rows named translations that looks like such

{
    "en": {
        "name": "pants",
        "description": "some description for en"
    },
    "es": {
        "description": "some description for en"
    }
}

I need a mysql query where for each element in my table I want to query results where the 'name' property is missing.

Improve this question
15
  • stackoverflow.com/questions/51234887/… Commented May 29, 2022 at 22:43
  • Can you show me an example query I can use? Commented May 29, 2022 at 23:24
  • Your JSON isn't valid could you correct that? Commented May 29, 2022 at 23:46
  • Is that JSON correct? Its stored in my database that way Commented May 30, 2022 at 0:06
  • You can try to paste your JSON of question to codebeautify.org/jsonviewer/y22d5d7a7 Commented May 30, 2022 at 0:18
Related questions
1
mysql query on json data
0
MYSQL Query on JSON for specific KEY:VALUE
8
How to query with a where clause in mysql json table
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.