how to use SQL "LIKE" in JDBC?
843854Jan 12 2005 — edited Aug 8 2007Tried to use the following syntax of "LIKE" in JDBC, but doesn't work with mysql 4.1:
String jsql =
"select IMG_ID,IMG_File_S FROM image WHERE IMG_Region=? and IMG_Tissue LIKE '%' ? '%' ";
pstmt = con.prepareStatement(jsql);
pstmt.setString(1, IMG_Region);
pstmt.setString(2, IMG_Tissue);
what's the right syntax to use "LIKE"? thanks a lot!