[ic] SQL with like

Sergey Sheykin sheich@mosinfo.ru
Wed, 27 Dec 2000 17:23:16 +0300

Hi, List!

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

Help, please!