Re: retrieve info

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

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

Comment on Re: retrieve info Select or Download Code

Replies are listed 'Best First'.
Re^2: retrieve info by bigup401 (Pilgrim) on Sep 12, 2018 at 13:48 UTC
thanks	[reply]
Re^3: retrieve info by marto (Cardinal) on Sep 12, 2018 at 13:56 UTC
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]