How to select non-matching rows from two mysql table

stockBoi Published at Dev

stockBoi

I have two tables, tableA and tableB as below:

tableA:

id | name       | age
---|------------|--------
1  | John       | 26
2  | Michal     | 30
3  | Watson     | 28
4  | samson     | 25

tableB:

name     | occupation
---------|---------------
John     | job
Michal   | business
watson   | job

I want to match two tables in such way that I can get non-matching row 'name:samson' from tableA. Which query (from PHP script) should I have to use?

Kumar V

Run this query in PHP. You will get the solution.

$qry = "SELECT a.* FROM tableA AS a, b.* FROM tableB AS b WHERE a.name <> b.name";

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-5

Comments

0 comments

From Dev

Select rows from a table matching other table records

From Dev

How to generate a query which consider data from one table and correspondingly fill 0 for non matching fields in mysql

From Dev

Select last two rows from mysql php

From Dev

How to get matching and non matching rows from a SQL Join

From Dev

Delete rows in MySQL matching two columns in another table

From Dev

MySQL insert id values from other table into matching rows

From Dev

MySQL select row with two matching joined rows from another table

From Dev

mysql: select rows from another table as columns

From Dev

Select rows from a table based on results from two other tables in mySQL using PDO

From Dev

Efficiently deleting rows from one table where not matching another [MySQL]

From Dev

join two table with non-matching rows

From Dev

MySQL: Select non matching rows in a join

From Dev

Select rows from a table matching other table records

From Dev

How to generate a query which consider data from one table and correspondingly fill 0 for non matching fields in mysql

From Dev

Delete rows in MySQL matching two columns in another table

From Dev

How to select bi-directional mapped rows from a table in MySQL?

From Dev

MySQL - How to select only two columns from a row in one table

From Dev

MySQL Best select query from two table

From Dev

How to select a set of rows from a table by matching columns?

From Dev

Make a SELECT query from two tables with one record from matching rows in mysql

From Dev

MySQL: Update rows in table, from rows with matching key in another table

From Dev

mysql select from table where two (or more) rows match,

From Dev

Select partialy matching rows from two differernt table in KDB?

From Dev

MySQL query to select rows matching criteria and rows related to the matching rows

From Dev

how to select one row from one table and multiple rows from other table using joins in mysql,

From Dev

How to SELECT none matching rows from one table to another?

From Dev

How to delete rows from one table matching another table?

From Dev

MYSQL: select all rows from table matching a combination and the opposite

From Dev

query to select non matching records from two tables

Related Related

Article