SQL with java search for a substring

Question

I have the following SQL line (within a loop):

ResultSet rs = stmt.executeQuery("SELECT * FROM item WHERE itemName='"+ string.get(1) +"'");

string.get(1) contains a different string each time the loop goes. in the current SQL line I will revive only the lines that are equal to string.get(1), but I'd like to get all lines that string.get(1) is a sub string of itemName I know it should go: %string.get(1)% however I don't know the exact syntax.

Anyone can help?

Do you mean you want to use likeclause of SQL?

Smit
– Smit

2013-01-07 18:34:57 +00:00
Commented Jan 7, 2013 at 18:34 — Smit
– Smit, Commented Jan 7, 2013 at 18:34

Erick Robertson · Accepted Answer · 2013-01-07 18:35:47Z

1

Use the LIKE clause in SQL.

ResultSet rs = stmt.executeQuery
    ("SELECT * FROM item WHERE itemName LIKE '%"+ string.get(1) +"%'");

answered Jan 7, 2013 at 18:35

Erick Robertson

33.1k13 gold badges73 silver badges98 bronze badges

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

7 Comments

Smit Over a year ago

This is correct but it will be open invitation for SQL Injection

Erick Robertson Over a year ago

Only if string.get(1) gets data directly from the user.

jeff ranz Over a year ago

hey Erick Robertson, thx for reply. the sql line you wrote is being complied however it doesn't return all the lines it should...

Erick Robertson Over a year ago

@jeffranz You haven't given me enough information to know why. Try logging the actual queries being executed and run them manually against the database.

Smit Over a year ago

@ErickRobertson Thats true but except OP, we don't know that.

|

ronpy · Accepted Answer · 2013-01-07 18:36:09Z

1

you mean this?

SELECT * FROM TABLE WHERE COL LIKE '%SOME_TEXT%';

answered Jan 7, 2013 at 18:36

ronpy

2621 silver badge13 bronze badges

Collectives™ on Stack Overflow

SQL with java search for a substring

2 Answers 2

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related