How can you query posts by advance custom field when the value is a serialized array? [closed]

I would advise using the built-in ACF functions for this. Elliot has provided a full toolbox for you and documentation for all field types:

<?php

// Conditional statement (Single Value)   
if(get_field('page_layout') == "col_1")
{
    //...
}


//Conditional statement (Multiple Values)
if( in_array( 'col_1', get_field('page_layout') ) )
{
    //...
}
?>

Check out the ACF documentation:
http://www.advancedcustomfields.com/resources/select/

Related Posts:

  1. Array sorting by custom field date
  2. Filtering multiple custom fields with WP REST API 2
  3. WP REST API: Order posts by meta value (acf)?
  4. meta_query with array as value
  5. Check for the existence of custom field
  6. pre_get_posts filter using numeric meta_query comparison (from dates)
  7. Using meta_query and custom fields within pre_get_posts to return posts within a numerical range
  8. Comparing arrays with meta_query in pre_get_posts
  9. ACF repeater field with meta_query
  10. Can an array be used as a meta_query value?
  11. sort by date in Advanced Custom Field
  12. Get specific repeater row (via advanced custom fields) based on Meta Query with Wildcards [closed]
  13. Using pre_get_posts for meta value of LIKE comparison on ACF repeater sub field
  14. Display post in order of ACF checkbox?
  15. How to write PHP array to render JSON-LD Markup for Job Postings, with ACF
  16. Changing a specific value inside a complex repeater/flexible content field (ACF)
  17. Filter posts by advanced custom field
  18. Get posts with multiple meta values
  19. Trying to select 1 item from an array
  20. ACF checkbox array is returning numbers, not labels [closed]
  21. Query by radio button ACF
  22. WP get_posts meta_query using ACF repeater field
  23. get_posts filter meta_query using ACF Checkbox
  24. Multiple orderby date arguments
  25. Display posts every specific day
  26. How to use germ_terms() with meta_query for ACF Taxonomy field?
  27. Help using an array in ‘exclude’ key of another array
  28. Convert number to date format within an array
  29. Time sort with meta_key using UNIX timestamp failing due to date differences
  30. update_post_meta and update_field ony working when saving the post
  31. Matching Serialized Arrays with meta_query
  32. Get the label from ACF checkbox [closed]
  33. How to update a custom post title from a front-end form using ACF fields?
  34. Query pages for use of a flexible content layout
  35. List of posts by day of the week
  36. ACF if / else checkbox [closed]
  37. ACF Plugin – Random Gallery Image with wp_get_attachment_image()
  38. Sorting custom admin column by value
  39. Update post meta value as date difference between two fields
  40. Get Current Post ID in functions php, meta query filter
  41. get all posts in custom post type by ACF field value
  42. Wrap Gutenberg blocks both frontend/backend (PHP approach with ACF)
  43. change value of fields created with advanced custom fields in the front
  44. Advanced Custom Fields Plugin: Get file URL into Parent
  45. html element to separate php variable strings – ACF datepicker
  46. Grouping posts by a custom meta value
  47. If/Else Statement for Advanced Custom Fields
  48. Search and replace not working for ACF Images
  49. How Do I Use a ACF Custom Field To Add A Slider ID?
  50. ACF relationship fields ‘The results could not be loaded’
  51. get_users with array as meta_value
  52. change order of images attached to post
  53. Hidden field in acf
  54. How do I ensure the social icons appear on all pages? [closed]
  55. Strip comma from last element in concatenated JSON string
  56. How to get file upload value in front-end to put in ACF image field
  57. Sorting the portfolio by an ACF? [closed]
  58. How to change the background color of my header dynamically based on a Custom Posts types color value?
  59. TinyMCE’s “Clear Formatting” button doesn’t remove lists and headings
  60. Prevent other hooks from firing after wp_update_post() outside of editor
  61. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  62. Can I use WP blocks in a template?
  63. Set post publish date by custom field
  64. Use Acf Repeater data as options for a different acf custom select field
  65. ACF get group fields from current post taxonomy
  66. Explore custom posts (CPT UI & ACF) database from WP UI
  67. Trouble with serialized metadata
  68. Transitioning Laravel App into WordPress (Portfolio Website)
  69. ACF – Get ID of relationship field in flexible content
  70. Creating permissions rules with ACF repeater field
  71. ACF meta_key and meta_value break loop
  72. WordPress meta query with meta serialized data array value
  73. Reading Content in an Array as it relates to a meta_query
  74. How to pass get images in homepage also in portfolio page?
  75. Srcset incorrect with Owl Carousel and ACF?
  76. ACF order relationship by date
  77. meta_query for user ID in array
  78. How to create an ACF shortcode with Repeater Field in WordPress functions.php?
  79. Generate custom sized images from certain images in media library
  80. Relationship field problem: Uninitialized string offset: 0 in
  81. Page returning ID from array, how to return the correct values for post in acf wordpress
  82. How to use an ACF taxonomy relationship field as part of the URL structure for a custom post type?
  83. wp_insert_post with advanced custum fields repeater
  84. Only list category if it has a custom field image
  85. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  86. Sort Posts with custom meta key by default which is currently set as optional
  87. Advanced custom fields – If/ while field problem
  88. How not to strip leading zero in advanced custom fields
  89. update_field() with repeater fields issue [closed]
  90. Advanced Custom Fields Image Crop
  91. Display ACF field only if value is greater than 0
  92. How to use ACF repeater? [closed]
  93. Updating post object via ACF breaks front-end
  94. I want to place a post before all others from an ACF boleen field
  95. How to indicate a parent child category relationship when bulk importing
  96. Use value from meta key array for use in WP_Query
  97. Filtering custom post admin listing page elements based on acf user field
  98. Parsing value from Lottie JSON file
  99. How do I add an ACF shortcode to a non-ACF page?
  100. Convert acf/gutenberg markup to html