[wp-hackers] meta_value contains text

[scribu]

Or, instead of hacking a core file, you could use the 'posts_where' filter
and add a condition like:

AND meta_value LIKE('New%');

-- 
http://scribu.net