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

6 votes130 views4 answers
Mysql group by date
SQL
6 votes135 views2 answers
Install psql mac
SQL
7 votes120 views1 answer
Connect mysql docker
SQL
9 votes127 views2 answers
Nosql databases
SQL
0 vote112 views1 answer
Count number of entires by months sql
SQL
0 vote125 views1 answer
How to to get time in sql
SQL
3 votes131 views1 answer
Sql add two values together
SQL
0 vote111 views1 answer
Postgresql find missing id
SQL
0 vote113 views1 answer
Copying query result to excel
SQL
0 vote116 views1 answer
Mysql select where field like in list
SQL