The snippet below shows how to search for strings ending with "hello%world"
Java Code:
st = con.createStatement();
rs = st.executeQuery
 ("SELECT value FROM vendors WHERE value LIKE '%hello/%world' {escape '/'} ");