Using select query with like operator and parameters in java

Question

I want to write this query:

SELECT * FROM products
WHERE name LIKE '%?%' 
OR description LIKE '%?%'

and execute it through java in spring web application. But here problem is when I use LIKE operator it has to be with literals, but when I write '%?%' java doesn't recognize ? like placeholders for parameters, when I add parameters I get error that there is no parameters in my query.

Also if I write %?% without literals I get syntax error.

why can't you use '%:name%' and '%:description%', much better, more readable and resolves your problem — Ramon Marques
– Ramon Marques, Commented Jun 5, 2017 at 17:01

Gordon Linoff · Accepted Answer · 2017-06-05 16:57:14Z

7

You can always use concat():

SELECT *
FROM products
WHERE name LIKE CONCAT('%', ?, '%') OR
      description LIKE CONCAT('%', ?, '%');

Or use the application to put the wildcards in the pattern string.

answered Jun 5, 2017 at 16:57

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using select query with like operator and parameters in java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related