我正在尝试根据多个自定义字段查询数据库中的帖子。如果值很简单,使用下面的代码就很容易了:
$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\'
";
但如何查询以数组形式存储的值,如:1:{I:0;s:8:“value”}?