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

1 vote147 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
4 votes159 views6 answers
List all tables in postgres
SQL
0 vote154 views1 answer
Oracle session statistics
SQL
1 vote152 views1 answer
Sql pick random row
SQL
12 votes163 views1 answer
Psql drop column
SQL
4 votes146 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote147 views2 answers
Sql having multiple conditions
SQL
0 vote151 views1 answer
Procedure excute monthly oracle
SQL
3 votes144 views1 answer
Oracle revoke grant
SQL
2 votes151 views1 answer
Mysql last 7 days including today
SQL