How do I find a string which ends with a particular keyword

[Hari]

How do I query on a particular field which is ending with a particular keyword.

Eg. I want find all the projects ending with "IES", we use %IES in SQL, but in JIRA it doesn't support % or *. So please let me know if I have to find all projects either starting with IES or ending with IES then how do I query ?

[Tessa Tuteleers]

Hi @Hari , 

just noticed this long outstanding open question. 

Perhaps you already found the answer, perhaps not, but as it is a short one, here goes: 

You can't. 

Jira supports wildcard searches for textfields, eg: 

summary ~ "prio*"

But not for other fields, like the Project.  
There are some workarounds, like using a project category, or using apps, you might want to look into other questions like:  https://community.atlassian.com/t5/Jira-questions/Wildcard-search-on-jira-and-projects-in-particular/qaq-p/839920