Searching for "one_word"
st = con.createStatement();
rs = st.executeQuery
("SELECT value FROM vendors WHERE value LIKE 'one/_word' {escape '/'}");
Searching for strings ending with "one%word"
st = con.createStatement();
rs = st.executeQuery
("SELECT value FROM vendors WHERE value LIKE '%one/%word' {escape '/'} ");
Find all rows in which a begins with the character "%"
st = con.createStatement();
rs = st.executeQuery
("SELECT value FROM vendors WHERE value LIKE '$%%' {escape '$'}");
Find all rows in which a ends with the character "_"
st = con.createStatement();
rs = st.executeQuery
("SELECT value FROM vendors WHERE a LIKE '%=_' {escape '='}");
Written and compiled by Réal Gagnon ©1998-2007
[ home ]