select * from testdata where key like '%substring%';
It uses regular expression form, not file glob form.
Try percent signs before and after the substring
you want to match.
wrote:
> I am not able to get Wildcards in PostgreSQL, I know its * (asterisk), but
> its not working. can someone show me a example or something?