LMSouq
general-dev Open

Using "like" wildcard in prepared statement

SS
ssn
1 month ago
3 views
Problem Description
I am using prepared statements to execute mysql database queries. And I want to implement a search functionality based on a keyword of sorts. For that I need to use `LIKE` keyword, that much I know. And I have also used prepared statements before, but I do not know how to use it with `LIKE` because from the following code where would I add the `'keyword%'`? Can I directly use it in the `pstmt.setString(1, notes)` as `(1, notes+"%")` or something like that. I see a lot of posts on this on the web but no good answer anywhere. PreparedStatement pstmt = con.prepareStatement( "SELECT * FROM analysis WHERE notes like ?"); pstmt.setString(1, notes); ResultSet rs = pstmt.executeQuery();

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base