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 vote328 views1 answer
Update view sql
SQL
0 vote318 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
1 vote320 views1 answer
Oracle create program if no exists
SQL
0 vote320 views1 answer
Mysql function variable
SQL
1 vote358 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote306 views1 answer
Postgresql copy backup table
SQL
12 votes349 views4 answers
Psql command not found
SQL
1 vote367 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote339 views1 answer
Connect by query in oracle
SQL
15 votes356 views6 answers
Laravel db transaction
SQL