Using like wildcard in prepared statement

Question

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

User · Accepted Answer

You need to set it in the value itself  not in the prepared statement SQL string    So  this should do for a prefix-match   notes   notes      replace                 replace                 replace                 replace             PreparedStatement pstmt   con prepareStatement           SELECT   FROM analysis WHERE notes LIKE   ESCAPE        pstmt setString 1  notes           or a suffix-match   pstmt setString 1        notes     or a global match   pstmt setString 1        notes

User · Answer

PreparedStatement ps   cn prepareStatement  Select   from Users where User FirstName LIKE      ps setString 1  name           Try this out

User · Answer

String query  select   from test1 where   selected   like     SelectedStr          PreparedStatement preparedStatement con prepareStatement query        where seleced and SelectedStr are String Variables in my program

User · Answer

We can use the CONCAT SQL function  PreparedStatement pstmt   con prepareStatement         quot SELECT   FROM analysis WHERE notes like CONCAT             quot   pstmt setString 1  notes   ResultSet rs   pstmt executeQuery     This works perfectly for my case

User · Answer

Code it like this   PreparedStatement pstmt   con prepareStatement       SELECT   FROM analysis WHERE notes like      pstmt setString 1  notes            Make sure that you DO NOT include the quotes     like below as they will cause an exception   pstmt setString 1       notes

User · Answer

String fname    Sam u0025    PreparedStatement ps  conn prepareStatement  SELECT   FROM Users WHERE User FirstName LIKE        ps setString 1  fname

[java] Using "like" wildcard in prepared statement

Examples related to java

Examples related to mysql

Examples related to jdbc

Examples related to prepared-statement