AnsweredAssumed Answered

SQL query question

Question asked by SkipGilleland on Apr 28, 2014
Latest reply on Apr 28, 2014 by SkipGilleland

Title

SQL query question

Post

     Not sure if this matters, but I have an ODBC connection with my Wordpress site and I need to get some information into a field in Filemaker with a calculation...just not sure on the calculation.

     2 tables (wp_posts, wp_postmeta)

     I have them connected correctly wp_post:id -> wp_postmeta:post_id

     Within the postmeta table there are three other fields (meta_id, meta_key, meta_value)

     I am trying to get all of the values within the field "meta_key" of "_my_meta_value_key".  

     Here is the Query my developer gave me..not sure if it helps, but incase I missed something.

     SELECT *
     FROM `wp_postmeta`
     WHERE `post_id` =22097
     AND `meta_key` LIKE '_my_meta_value_key'
      
     The attached image is what happens when I search for the post_id of 22097 in FM, not when I run the above mySQL query.

Volleyball_Tryouts_-_2_.png

Outcomes