in reply to retrieve info

what does $input look like? does it contain a %?

possibly you might want something like $search->execute('%'.$input.'%'); SQL LIKE Operator

Replies are listed 'Best First'.
Re^2: retrieve info
by bigup401 (Pilgrim) on Sep 12, 2018 at 13:48 UTC

    thanks

[reply]

      As part of basic testing/debugging you should always run your the SQL you have in your code against your database using your test data using one of the standard interfaces. For anything complex I develop my SQL code in SQL Developer (oracle specific) to ensure it all works as expected, before embedding it in my perl code.

[reply]

In Section Seekers of Perl Wisdom