query « regex « Python Data Type Q&A

1. write regex equivalent to like statement in query    stackoverflow.com

i have sample query

 select c.name , c.id from company c where
 c.name like 'Hoder%' and c.name like 'Stock%' amd c.name like 'Colour%'
 and c.name like '%Delete' and c.name like '%Regular' ...