Basically, I have a table with an indexed varbinary field in it.
I want to say: return all rows whose varbinary field starts with (an array of bytes).
How do I do this in Java? I have a PreparedStatement with "SELECT * WHERE data LIKE ?" but if I set the binary array as an argument with setBytes, how do I specify that the LIKE query should be a prefix (as opposed to another type of regular expression)?