[ic] SQL with like
Wed, 27 Dec 2000 17:23:16 +0300
I have problems with SQL -searches, using "like" method.
For example, i use :
<FORM ACTION="[area search]">
Type: <INPUT TYPE=text NAME=mv_searchtype VALUE=sql>
<INPUT TYPE=hidden NAME=mv_matchlimit VALUE=50>
Authors: <INPUT NAME="authors">
Title: <INPUT NAME="title">
<input type=text NAME="mv_sql_query"
VALUE="SELECT * FROM products WHERE authors like authors
AND title like title" size=40>
<input type=submit value=search></form>
- This request is executed very longly, and sometimes generally is
But the same SQL through BDE is executed much fastly.
And, if I use "=" instead of "like" - all works fine.
I use DBI-1.14, DBD Oracle -1.06, Interchange 4.6.1, Perl 5.00503 and Oracle