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 vote124 views1 answer
Set default value now() date
SQL
0 vote123 views1 answer
Go install mysql
SQL
1 vote140 views1 answer
Write a query to create an empty table from an existing table?
SQL
23 votes131 views4 answers
Sql server substring
SQL
0 vote123 views1 answer
Oarcale list objects
SQL
-1 vote130 views1 answer
Insert results of a stored procedure into a temporary table
SQL
1 vote124 views1 answer
Not exists mysql
SQL
9 votes131 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote119 views1 answer
Mysql function variable
SQL
0 vote129 views3 answers
CONTACT FORM SQL
SQL