How to find fields in the database by the pattern "vice versa"?

Question

PostgreSQL

There is a column in the database, it has values:

____________________
|_____template_____|
|  mri_head_full   |
|  mri_head_short  |
|  mri_head_%      |
|  mri_%           |
|  ct%             |
|  ct_head%        |

I need to select all values ​​whose patterns match, for example " ct_head_short ", namely ct% and ct_head% . Is it real?

Answer 1

where 'ct_head_short' like template
seqscan is expected, but will work for a small number of rows