Clarification on javax persistence named query using the like statement

Question

I have a named query to search for customer name as shown below. This is currently matching all the customers whose names have the specified search criteria in any part of their name (equivalent to %search%).

"SELECT t FROM Customer t WHERE t.name like :search"

How do i specify the named query so that it matches only the start of the name with the criteria specified using named queries?

Regards,

score 3 · Accepted Answer · answered Sep 27 '13 at 06:56

3

You can do it this way. Just append the % symbol to the start or end(depending on your requirements) of the keyword to be searched.

query.setParameter("search", searchKeyword+"%"); // Searches for words starting with searchKeyword

answered Sep 27 '13 at 06:56

Rahul

44,383
11
84
103

score 1 · Answer 2 · edited Sep 27 '13 at 07:16

1

SELECT t FROM Customer t WHERE t.name like :search

and set the Parameter as

query.setParameter("search", value + "%" )

edited Sep 27 '13 at 07:16

Tobia Zambon

7,479
3
37
69

answered Sep 27 '13 at 06:57

Siva

1,938
1
17
36

Clarification on javax persistence named query using the like statement

2 Answers2