By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SET @json := '
{
"quantity": 1,
"amount": 10,
"token": "27a6a39167bd6287f0c84e1534df232990e28d2d",
"items": [
{
"quantity": "1",
"amount": 10,
"ht_amount": 9.090909090909092,
"tva_amount": 0.9090909090909092,
"ttc_amount": 10,
"item": {
"id": 108828,
"user_id": 38141,
"title": "Teste Offer",
"description": "<p>lorem ipsum<\/p>",
"type_offer": "offer",
"brand": null,
"amount": 25,
"type_shipping": [
"hand"
],
"amount_shipping": null,
"tag_categories": [
4
],
"geo_lat": "0",
"geo_long": "0",
"open_time": null,
"is_flash_offer": 0,
"is_activate": 1,
"is_offer_moderate": 0,
"is_boost": 0,
"created_at": "2020-01-29 14:42:23",
"updated_at": "2020-01-29 14:42:24",
| JSON_PRETTY(@json) |
|---|
| { "items": [ { "item": { "id": 108828, "slug": "teste-offer-108828", "user": { "id": 38141, "web": null, "city": "Paris", "role": "pro", "slug": null, "email": "fogang24@gmail.com", "phone": "0698452884", "token": "", "parent": 0, "address": "Etoug, Cameroun", "birthday": null, "facebook": null, "address_2": null, "full_name": "Holly yannick", "instagram": null, "is_active": 1, "is_verify": 1, "last_name": "Holly", "stripe_id": "cus_GSDlGFUn1qWrDU", "accept_cgu": 1, "country_id": 0, "created_at": "2019-12-27 08:05:08", "first_name": "yannick", "is_pending": 0, "is_suspend": 0, "updated_at": "2019-12-30 08:25:58", "accept_year": 1, "postal_code": "0000", "user_company": { "id": 53, "slug": null, "siret": null, "user_id": 38141, "banniere": null, "code_naf": null, "workplace": "", "created_at": "2019-12-27 08:05:08", "tva_number": null, "updated_at": "2019-12-27 08:05:08", "company_web": null, "description": null, "company_name": "", "url_banniere": "", "company_status": null, "company_facebook": null, "company_instagram": null, "company_save_date": null }, "profile_image": null, "is_user_complete": 0, "url_profil_image": "", "email_verified_at": "2019-12-27 08:05:08", "is_admin_validate": 1, "is_payment_active": 0, "is_pro_advertiser": 0, "payment_method_id": "pm_1FvJJdFfpClgVPUbz2wq9niK", "created_date_format": "27/12/2019 08:05:08", "has_default_payment_method": false }, "brand": null, "title": "Teste Offer", "views": null, "amount": 25, "clicks": null, "address": "Etoug, Cameroun", "favoris": null, "geo_lat": "0", "user_id": 38141, "benefits": "", "facebook": null, "geo_long": "0", "is_boost": 0, "site_web": null, "instagram": null, "open_time": null, "tva_offer": 10, "created_at": "2020-01-29 14:42:23", "type_offer": "offer", "type_price": "price", "updated_at": "2020-01-29 14:42:24", "description": "<p>lorem ipsum</p>", "is_activate": 1, "postal_code": "0000", "offer_images": [], "type_purchase": "purchase_camcha", "type_shipping": [ "hand" ], "website_offer": "", "is_flash_offer": 0, "tag_categories": [ 4 ], "amount_shipping": null, "discount_amount": 10, "is_camcha_offer": 0, "real_categories": [ { "id": 4, "name": "Services", "slug": "services", "image": null, "position": 7, "image_url": "", "parent_id": 0, "created_at": "2019-12-12 15:24:11", "updated_at": "2019-12-12 15:24:11", "description": null, "is_activate": 1, "is_product_show": 0 } ], "is_offer_moderate": 0, "created_date_format": "29/01/2020 02:42:23", "discount_percentage": "", "is_default_free_offer": 0 }, "amount": 10, "quantity": "1", "ht_amount": 9.090909090909092, "ttc_amount": 10, "tva_amount": 0.9090909090909092 } ], "token": "27a6a39167bd6287f0c84e1534df232990e28d2d", "amount": 10, "quantity": 1 } |
SELECT JSON_EXTRACT(@json, '$.items[0].item.tva_offer')
| JSON_EXTRACT(@json, '$.items[0].item.tva_offer') |
|---|
| 10 |