Help coderanch get a
new server
by contributing to the fundraiser

Paulo Pinto

Greenhorn
+ Follow
since Oct 27, 2008
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Paulo Pinto

I'm using now JBoss 4.2.3.GA and that SUBSTRING doesn't seem to work for this purpose anymore.

But I tried this and it worked for me:


This simulates the query:


You can even do a CONCAT(CONCAT('%', ?1), '%') if you need something like '%?1%' instead.
15 years ago