$rows = $wpdb->get_results($wpdb->prepare(

"
SELECT *
FROM {$wpdb->prefix}postmeta
WHERE meta_key LIKE %s
    AND meta_value REGEXP %s
",
'colours_%_colour', // meta_name
'red' // meta_value

));