Your Perl syntax is broken. If you start a quoted string with qq(, then it won't end until the matching ), but you have a double quote followed by Perl code that you clearly expect to run (".join...). So please cut'n'paste the actual code you are using (since you say you get rows returned you must have a working query, just not quite the right query).

Thanks for your help, I am still very confused and appreciate all your advice and help.

This is the entire mysql statement that runs without error but pulls records back that it shouldn't.

    my $data = qq(SELECT engine, name1, name2, name3, name4, lable1, l
+able2, lable3, lable4, settings1, settings2,
                  settings3, settings4 FROM special_fields WHERE engin
+e IN (".join(",",map($dbh->quote($_), @choices)).") AND 
                  settings1="public" OR settings2="public" OR settings
+3="public" OR settings4="public");
    my $sth = $dbh->prepare($data);
    $sth->execute() or die $dbh->errstr;

    my ($engine, $name1, $name2, $name3, $name4, $lable1, $lable2, $la
+ble3, $lable4, $settings1, $settings2,
                  $settings3, $settings4);
    $sth->bind_columns(\$engine, \$name1, \$name2, \$name3, \$name4, \
+$lable1, \$lable2, \$lable3, \$lable4, 
                       \$settings1, \$settings2, \$settings3, \$settin
+gs4);
[download]

It's long code, I apologize, there's like 12 columns in this table which makes it look messy.

The thing really confusing me is the entire JOIN statement, it was code from a previous node on here.

All I'm trying to do is have a variable (@choices) with a few names (engines column) and pull back only the records found in the array. That's why the join() is there and that's why I'm completely lost.

When I wrap ( ) around AND ( ... or ... or ... ) I get 0 results back.

Print out your statement. It isn't what you expect. Then reread what I wrote to see why.

- tye        

As tye suggested, you need parentheses around all of the OR options too.