hi all,
I am having problems with issuing a HQL search query which has a "like" clause in it...the database that i am using is MySQL 5.0
for example my HQL is something like
I have highlighted the areas due to which the error is coming up.. i get some errors saying that the '%' + ? + '%' cannot be recognised , and that it is not correct MySQL syntax,,, when i investigated, i found out that mysql does not allow concatenation of strings to be done with '+' ,,
then i did something like LIKE '%?%' , but that also didnt work
,,
would appreciate if some one call tell a possible workaround for this,, basically i want to get thru this SQL query which uses "like"
Thanks
[ January 18, 2007: Message edited by: Mark Spritzler ]