Mysql search multiple tables

SELECT
  users_first_name,
  users_last_name
FROM
  (
    (
      SELECT
        users.first_name AS users_first_name,
        users.last_name AS users_last_name
      FROM
        users
        INNER JOIN companies ON companies.id = users.company_id
      WHERE
        (
          users.last_name LIKE 'TERM%'
        )
    )
    UNION
      DISTINCT (
        SELECT
          users.first_name AS users_first_name,
          users.last_name AS users_last_name
        FROM
          users
          INNER JOIN companies ON companies.id = users.company_id
        WHERE
          (users.first_name LIKE 'TERM%')
      )
    UNION
      DISTINCT (
        SELECT
          users.first_name AS users_first_name,
          users.last_name AS users_last_name
        FROM
          users
          INNER JOIN companies ON companies.id = users.company_id
        WHERE
          (companies.name LIKE 'TERM%')
      )
  ) AS union1;

Source: gist.github.com

Similar codes

2 votes194 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote244 views1 answer
Mql5 datetime get hour
SQL
11 votes215 views4 answers
Reset identity column values in sql server
SQL
0 vote192 views1 answer
Python mysql show databases
SQL
-1 vote226 views2 answers
Full join sql
SQL
0 vote216 views1 answer
Mysql delete from where like
SQL
0 vote219 views1 answer
Oracle enable chain
SQL
2 votes297 views1 answer
How to select from mssql
SQL
5 votes147 views1 answer
Mongodb vs
SQL
0 vote181 views1 answer
Difference between cross apply and inner join
SQL