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

0 vote171 views1 answer
Mysql cdn link
SQL
11 votes176 views2 answers
Oracle all source
SQL
1 vote164 views1 answer
Psql show with user is logged in
SQL
1 vote187 views1 answer
How to start with sql
SQL
0 vote201 views1 answer
Group by 15 minute interval sql server
SQL
0 vote196 views1 answer
Uncheck constraints and delete from table
SQL
2 votes129 views1 answer
Oracle current date without time
SQL
0 vote179 views1 answer
Sql beginning of previous month
SQL
2 votes193 views2 answers
Postgres add column integer
SQL
0 vote191 views1 answer
Get the Db column names from a SqlDataReader
SQL