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

3 votes286 views1 answer
Force using index oracle
SQL
0 vote356 views1 answer
Jpa generationtype sequence mysql
SQL
2 votes287 views4 answers
List databases in sql server
SQL
0 vote263 views1 answer
Increment id in mysql
SQL
3 votes298 views3 answers
Start postgresql ubuntu
SQL
0 vote268 views1 answer
Database springboot
SQL
0 vote288 views1 answer
Populate db from command line postgres
SQL
92 votes514 views6 answers
Substring
SQL
1 vote284 views1 answer
Sql find column name like
SQL
1 vote276 views1 answer
User privileges postgresql information_schema
SQL