We can do this:
select count(*) from regexp_matches('Great London', 'Great London|Information Centre|Department for Transport', 'g');
Is it possible to allow null as an option? something like this
select count(*) from regexp_matches('Great London', 'null|Great London|Information Centre|Department for Transport', 'g');
Regards,
David