Refer to the taxonomy parameters section of the WP_Query documentation for more examples.
Custom Field Parameters
Show posts associated with a certain custom field. Following example displays posts from the ‘product’ post type that have meta key ‘featured’ with value ‘yes’, using ‘meta_query’: