I sussed this out in the end and it's actually very simple - you simply need to set the SearchCondition property of the SearchResults user control:
<uc1:SearchResults runat="server" ID="ucSearchResults" Indexes="MySite-Pages" SearchCondition="+MyCustomFieldColumnID:(int)1" />
In addition, make sure that those values are indexed in the search.