Retrieving custom field array value through db query

Question

I'm trying to query the database for posts based on multiple custom fields. This is easy enough with the code below if values are simple:

 $querydetails = "
       SELECT wposts.*
       FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
       WHERE wposts.ID = wpostmeta.post_id
       AND wpostmeta.meta_key = 'field'
       AND wpostmeta.meta_value = 'value'
       AND wposts.post_status = 'publish'
     ";

But how do I query a value that is stored in array form, like a:1:{i:0;s:8:"value";} ?

Search for meta_query here on WPSE.

kaiser
– kaiser

2012-03-07 09:47:22 +00:00
Commented Mar 7, 2012 at 9:47 — kaiser
– kaiser, Commented Mar 7, 2012 at 9:47

krazymatty · Accepted Answer · 2012-03-07 16:45:59Z

0

You can't query the database for a value in the array. However you can grab the entire array and parse the array to get your value. Check out PHP ARRAY-VALUES. More than likely you'll need to use a for each statement.

Does the value your trying to get appear in the same spot in the array? If so it should be easier to target.

Good Luck!

answered Mar 7, 2012 at 16:45

krazymatty

1078 bronze badges

Add a comment |

Community · Accepted Answer · 2017-05-23 12:40:08Z

0

Simply You can't because it is not possible!

about a year a go i asked that same question (almost) and the answer i got was

The only possible case when serialized data is acceptable is when you don't need to search or order by through that data.

So if your data is stored as serialized array you cant filter by it.

edited May 23, 2017 at 12:40

CommunityBot

1

answered Mar 7, 2012 at 12:43

Bainternet

67.8k8 gold badges132 silver badges188 bronze badges

Add a comment |

poisonborz · Accepted Answer · 2012-03-07 22:13:01Z

While the method in the question may not be possible, I realized that in my case, it's easier (and possible!) to modify the query rather than querying the database directly. The example below works for array format as it will find the string contained in it ('like' switch).

$args = array(
    'post_type' => 'termek',
    'meta_query' => array(
        array(
            'key' => 'property',
            'value' => 'value',
            'compare' => 'like'
        ),
        array(
            'key' => 'property',
            'value' => 'value',
            'compare' => '='
        )
    )
 );
?>
<?php query_posts($args); ?>

Stack Exchange Network

Retrieving custom field array value through db query

3 Answers 3

Your Answer

Hot Network Questions

Retrieving custom field array value through db query

3 Answers 3

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions