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 vote277 views1 answer
Delete mysql ubuntu 20.04
SQL
0 vote244 views1 answer
Import sql in postgresql
SQL
0 vote249 views2 answers
Uninstall postgresql mac
SQL
0 vote229 views1 answer
Sql insert tuple
SQL
0 vote251 views1 answer
Less than date query sqlachemy
SQL
2 votes235 views1 answer
Set column to not null mysql
SQL
1 vote253 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote233 views1 answer
Mysql command line ubuntu
SQL
1 vote274 views1 answer
Sql server set variable if exists
SQL
2 votes228 views1 answer
Oracle index size
SQL