Filtering posts by WORD in custom field

Question

I need to filter my posts in categories pages, by showing only posts that have specific WORD in custom field value. I need php code that i should add in loop for this category.

Details: I need loop query that will say - show posts in this category (crocs) only if custom field hey 'brand' contain the same value (crocs). BUT note, in custom field 'brand' i have more brands, for example 'diesel, crocs, fendi'. Now i need post to show if value contains crocs, not if it's equal to crocs (as other brands can be present).

Thanks a lot for your help. Maybe this is basic, but I am noob and trying to learn and understand WP :)

Cheers, Dean

Answer 1

args = array(
    'post_type' => 'product',
    'meta_query' => array(
        array(
            'key' => 'brand',
            'value' => 'crocs',
            'compare' => 'LIKE'
        )
    )
 );
$query = new WP_Query( $args );

http://codex.wordpress.org/Class_Reference/WP_Query