How to get value "A" from database where WHERE is passed by variables?

Question

WordPress

Something like this table:

I'm trying to get a row with id 2, having the variables $bar and $hat. Let's say $bar = 5; $hat = 2; (as in the picture) and get far "A" from the second line. I do it like this:

$sql = $wpdb->get_var
($wpdb->prepare("SELECT far FROM table WHERE bar =%s", $bar, "AND hat = %s", $hat ));

But in this way I get the 1st line instead of the 2nd one, because far both there and there = "A" ?
Why is that? How can I fix it? Thank you.

Answer 1

$wpdb->prepare("SELECT far FROM table WHERE bar = %s AND hat = %s", $bar, $hat )

here you can read