MySQL Forums
Forum List  »  PHP

extracting data including json array from joined tables
Posted by: loren mehl
Date: May 05, 2017 02:57PM

Hello,

Developers our company paid to write an app for us used json data which i've never accessed.

I'm new to mysql and phpmyadmin but i want to do some simple select statements and one is to pull transaction data from a table that has regular data and json data. I need to join two tables and i can get the data to pull for a single row of data but not more than that.

I'm trying to do this in the phpmyadmin console and our developers don't want to part with the info even if i pay for the time it takes to pass it on.

Can anyone help? Basic query i'm using is below.

Thanks very much!

SELECT
`id`,
`user`,
`hotelID`,
`cartID`,
`RoomId`,
`meta_value`
FROM
`wp_cart` a
INNER JOIN
`wp_usermeta` b ON b.user_id = `id`
WHERE
`meta_key` = 'xyz_MemberNo'

Options: ReplyQuote


Subject
Written By
Posted
extracting data including json array from joined tables
May 05, 2017 02:57PM


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.