I am trying to pull a random post content along with its meta data from a custom post type called "BRAND" (try saying that again ^_^).
I can pull one meta data, but I cannot pull multiple meta data for that post. My code is as follows:
SELECT p.ID, p.post_content, m.meta_key, m.meta_value FROM wp_posts p INNER JOIN wp_postmeta m ON p.ID = m.post_id WHERE p.post_type = 'BRAND' AND p.post_status = 'publish' AND m.meta_key LIKE 'brand-%' ORDER BY RAND() LIMIT 1
Note, that the meta_key can be something like "brand-a", "brand-b", "brand-c", etc.
How do I pull all those meta_keys? Thanks!