MySql to Wordpress Query
I need to count the number of value 1 from wp_ul_locked on wp_usermeta i
try this code
$wpdb->get_var("SELECT COUNT(*) WHERE 'meta_key' LIKE 'wp_ul_locked'");
or
$wpdb->get_var("SELECT COUNT(*) FROM $wpdb->usermeta WHERE meta_key = '1'");
or
$wpdb->get_var("SELECT COUNT(*) FROM $wpdb->usermeta LIKE 'wp_ul_locked'
WHERE meta_value = '1'");
in this mode return count of all wp_ul_locked not only value 1
$wpdb->get_var("SELECT COUNT(*) FROM $wpdb->usermeta WHERE meta_key LIKE
'wp_ul_locked' = '1' ");
but return empty or error
Where is my error?
No comments:
Post a Comment