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 vote163 views2 answers
Mysql set foreign_key_checks=0
SQL
1 vote164 views1 answer
Mysql datetime with timezone offset
SQL
17 votes187 views3 answers
Postgresql version command
SQL
0 vote172 views1 answer
Sql replace id with name from another table
SQL
0 vote202 views4 answers
Convert databse to achieve log mode oracle
SQL
1 vote226 views2 answers
Sql split string by space
SQL
0 vote153 views1 answer
QCompleter con sql
SQL
3 votes161 views1 answer
Uppercase and lowercase in sql
SQL
0 vote186 views1 answer
Sql comand for removing data from table
SQL
0 vote167 views1 answer
C# mysql update statement set value to null
SQL