Separating out a DB field in SQL statement ?
It looks like your address column is formatted as a JSON document. MySQL 5.7 and later versions support JSON functions, so you can do the following query:
SELECT
JSON_UNQUOTE(JSON_EXTRACT(u.address, '$.city')) AS `city`,
JSON_UNQUOTE(JSON_EXTRACT(u.address, '$.first')) AS `first`,
JSON_UNQUOTE(JSON_EXTRACT(u.address, '$.state')) AS `state`,
JSON_UNQUOTE(JSON_EXTRACT(u.address, '$.second')) AS `second`,
JSON_UNQUOTE(JSON_EXTRACT(u.address, '$.country')) AS `country`,
JSON_UNQUOTE(JSON_EXTRACT(u.address, '$.zipcode')) AS `zipcode`
FROM ... There's also a shorthand syntax:
SELECT
u.address->>'$.city' AS `city`,
...and similar for each field... 156 0 7
Write a Comments
* Be the first to Make Comment
In Offer
ZISAAN Latest Striped Sleeve[Less Summer Gift TOP for Women & Girls (Blue, Small)
Suson Men Synthetic Lace Up Formal/Office/Casual/Derby Shoes
Van Heusen Women's Cotton Printed Anti-Bacterial Bikini (Pack of 3)
Underwear Comfortable fit Throughout Pregnancy
Croma 1 Ton 3 Star Split Fixed Speed AC (Copper, Blue Fins, PM 2.5 Filter with activated carbon, R-32 Green Refrigerant, 2022 Model, 5 Years Compressor Warranty, CRAC7721, White)
SHOWTIME Gift for Husband Special Romantic Gift for Wife
Van Heusen Antibacterial Non Padded Non Wired Slim Fit Cotton Bra
Livpure Smart Solid Window Polyester 5 feet Curtains with tieback( Beige ) Set of 2
SBAPRIME 3pcs-Set Men's Gift Set Men and Boys Watch, Cap & Sunglasses Combo Set Birthday Present
Sillyboom Maternity Boy Peeking T-Shirt for Pregnant Women
Recent Posts
A Comprehensive Guide to...
Ecommerce in 2023- 8 Top...
Top 10 Tips for How to st...
Tips for small business o...
Top effective strategies...
AI and Jobs: Debunking th...
Tour and Travel Website a...
Digital marketing service...
Importancy of prototyping...
Difference between Chatgp...
Contact Details
(+91) 81306 40 966
(+91) 78277 51662
live:trimwebsolutions
New Delhi, India
