Select statement

Hi,
Anyone know the correct syntax for using a select/comparison statement in
the current version of mysql?
I'm having extreme difficulty doing the following. Comparing a value in a
table to a variable passed in.

my $sth = $dbh->prepare("SELECT candidate,task, estimatedSize, approved,
completionDate, successMeasuredBy FROM waitingroom WHERE '$user =
candidate'");

Thanks in advance,
Mark.


************************************************************ **********
This document is strictly confidential and is intended for use by
the addressee unless otherwise indicated.
Allied Irish Banks
************************************************************ **********


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org