Hi everybody,

till now I have gained a lot of experience using hibernate. Nevertheless I'm struggling with a very simple problem: how can I realize a very simple and 'tolerant' search-function with hibernate?

I have a couple of "text-components" and I want to create a jsp-page on which the can enter something like "search: 123* " but how can I do this?

Till now I just know the "SELECT comp FROM Textcomponent as comp WHERE text='123*'"-query but this will return no results because it will interpret the * as a character and not as a wildcard.

So how can I realize such a search-function? What is the correct SELECT-query???

I'm sorry for posting this message twice, my Konqueror-Browser has a very buggy "shortcut-button"-feature which sometimes is hard to controll...

like

thank you, that was exactly the one and only keyword I was looking for, now I can solve this problem ;)