MySQL/Perl LIKE $string questionby peppiv (Curate)
|on Jan 31, 2002 at 19:16 UTC||Need Help??|
peppiv has asked for the
wisdom of the Perl Monks concerning the following question:
This is probably more of a MySQL question.
Let's start with the code:
Returns "execute called with 1 bind variables when 0 are needed"
What I'm trying to accomplish is searching the 'applicants' TABLE by column name 'last_name' using the LIKE statement. If I merely place text into this code it works. However, trying to pass a variable into it doesn't work. The $string in the sth works with a placeholder if I don't use LIKE. I've tried escaping the characters, putting the string directly in the LIKE statement and every variation I can think of.
Does anyone have any suggestions? I've looked at all my docs and mysql.com and found nothing about this.
your lucky lotto numbers are 10 20 30 40 50!