How to check variable exist in database wordpress

Question

In Function.php, I want to check if my variable exist in a table of wordpress database, but it don't work.

global $wpdb;
    $count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM $wpdb->pincode_distro1 WHERE pincode = $the_order->shipping_postcode"));
    if($count == 1) { echo 'distro 1'}
    else { echo 'distro 2'}

Answer 1

I guess you won't need $wpdb->prepare() for that, tried this way?

$count = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->pincode_distro1 WHERE pincode = '$the_order->shipping_postcode'");

Answer 2

remove $wpdb from table name . Code will work

from

$count = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->pincode_distro1 WHERE pincode = '$the_order->shipping_postcode'");

to

$count = $wpdb->get_var("SELECT COUNT(*) FROM pincode_distro1 WHERE pincode = '$the_order->shipping_postcode'");