How to query on a part of a value of a custom field?

Question

In my project, there is a custom field called "Build". This field contain a value like below

"Front-End-Version-3.3-555"

"Front-End-version-3.3-556"

and in further increments , 557, 558, 559... and so on.

Now, if i want to find builds between say "Front-End-version-3.3-556" and "Front-End-version-3.3-559", how do i search for all items?

Jagriti Sharma_5cyh46 · Answer

yes. i am using text field.

Sreenivasaraju P · Answer

do you mean , you are using text field . If you are using text field, you can't use = or in operator ~ , !~ , is , is not operators only

Jagriti Sharma_5cyh46 · Answer

I tried using above method, but looks like "IN" operator is not available for builds field. The only allowable operators are ~ !~ is is not