How to do a simple "search"-function with wildcard

thurisaz · **Joined:** Sat Jun 04, 2005 1:15 pm **Posts:** 5

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 do a simple 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*' but this query will not return any results because it will interpret the * as a character.

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

zesj · **Joined:** Tue May 24, 2005 10:19 am **Posts:** 65

try like+%

Quote:

from eg.DomesticCat cat where upper(cat.name) like 'FRI%'

use % , not *.

read http://www.hibernate.org/hib_docs/reference/en/html_single/#queryhql-expressions

thurisaz · **Joined:** Sat Jun 04, 2005 1:15 pm **Posts:** 5

thank you!

ramnath · **Posted:** Sun Jun 05, 2005 9:45 am

Hi

add this to to ur like
replace("%", "*")