Support Forums: Message List - PreparedStatement using LIKE clause

PreparedStatement using LIKE clause

Wed, 15 Dec 2010 19:55:28 -0500

Hi,

...

here is the answer

Sun, 10 Apr 2005 18:24:06 -0400

% is used as a wildcard in every SQL implementation I have seen. I believe its in the ANSI SQL Standard.

so when you do your do the following

String whereValue = '%myVal%'

pstmt.setString(1,whereValue);

only do the %...

PreparedStatement using LIKE clause

Fri, 08 Apr 2005 14:37:33 -0400

I guess the prepared statement doesn't work for the clauses of type "like" or "in".

I got bitted by "in" for sure and I suspect it is case for "like" too.

ex: select * from employee where employee_id...

Still no success

Fri, 08 Apr 2005 06:31:39 -0400

It seems that not even this is working...

ps = conn.prepareStatement("SELECT * FROM table WHERE fieldName LIKE ?");
ps.setString(1, "Fubar");

Might I have some weird config problem? Running Java 1.4.2 on Win XP with...

RE: PreparedStatement using LIKE clause

Thu, 07 Apr 2005 23:05:39 -0400

String sql = "SELECT * FROM table WHERE field LIKE ?;
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, "A%\"");

PreparedStatement using LIKE clause

Thu, 07 Apr 2005 10:34:31 -0400

Sorry Udayan, that doesn't change the result. Besides, not having to add the extra ' before and after the [var] is my main reason for using ps.setString.

PreparedStatement using LIKE clause

Thu, 07 Apr 2005 10:23:20 -0400

ps.setString(1, "'" + var + "'");

PreparedStatement using LIKE clause

Thu, 07 Apr 2005 09:21:30 -0400

I have a working connection and the following works
String sql = "SELECT * FROM table WHERE field LIKE 'A%'";
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();

I do however want to be able to...