sql - Exclude row when the value in column B is present somewhere (in another row) in column C -

-

as title describes i'm looking way exclude entire row select clause when value in column b of row present anywhere in column c of same table.

select col_a, col_b, col_c table  col_b not in (select col_c table)

should it.


Comments

Post a Comment

Popular posts from this blog

mysqli - Php Mysqli_fetch_assoc Error : "Warning: Illegal string offset 'name' in" -

-
this question has answer here: php mysqli returns 1 row 3 answers warning: illegal string offset 'name' in c:\xampp\htdocs\connection\index.php on line 31 1", please can me. <?php include('config.php'); $conn = mysqli_connect(db_host, db_user, db_pass, db_name); $sql = "select * users"; $result = mysqli_query($conn, $sql); $rows = mysqli_fetch_assoc($result); ?> and in body tag <?php foreach ($rows $row) { echo $row['name']; }?> you should use mysqli_fetch_all() here rows within $rows @ once. $sql = "select * users"; $result = mysqli_query($conn, $sql) or die(mysqli_error($conn); $rows = mysqli_fetch_all($result); echo "<pre>"; print_r($rows); // check result
Read more

html - Cut text on left side inside button while centering -

-
i need have button text (f.e. "add basket") fluid in width. if button width little show "add basket" must cut "basket" only. did achieve of splitting <span class="text">add basket</span> into 2 parts , reverse order them in dom <span class="text">basket</span><span class="text text-prefix">add to&nbsp;</span> and show them in correct order adding .text{ float: right; } however, text inside button must centered, not work far. here fiddle, i'd appreciate ideas: https://jsfiddle.net/5cavrrhc/ under circumstances, want avoid using js this. solution ok, here go: https://jsfiddle.net/6etabchg/4/ ok, co-worker , found solution works nicely. make button position: relative make wrapper display: flex; flex-wrap: wrap-reverse; justify-content: center; reverse order make both inner spans display: inline-block;flex-shrink: 0; make 1 span should remain or...
Read more

php - Hide Categories from WordPress Dashboard by ID and Custom Post Type -

-
i went searching solution hide specific categories id on wordpress dashboard individual custom post types. stumbled upon following code , able half way there hiding categories logged in user. add_action( 'admin_init', 'wpse_55202_do_terms_exclusion' ); function wpse_55202_do_terms_exclusion() { if( current_user_can('administrator') ) add_filter( 'list_terms_exclusions', 'wpse_55202_list_terms_exclusions', 10, 2 ); } function wpse_55202_list_terms_exclusions($exclusions,$args) { return $exclusions . " , ( t.term_id <> 43 ) , ( t.term_id <> 42 )"; } now want alter code hide id specified categories taking custom post type account. know, can pass argument current_user_can i'm not sure how phrase it. unfortunately custom taxonomy have implemented in other aspects of site not going work in instance. i thought had swap if statement conditional get_post_type did not work. ideas? 'andytoday...
Read more