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 vote290 views1 answer
Import mysql dump database command line linux
SQL
4 votes263 views2 answers
Dbms_scheduler stop job
SQL
0 vote280 views1 answer
Create bdd mysql
SQL
1 vote264 views1 answer
Scaffold mysql database
SQL
0 vote274 views2 answers
Sql drop view if exists
SQL
0 vote266 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote278 views1 answer
Get first 3 letter of department name in sql
SQL
26 votes225 views10 answers
Insert in to table sql
SQL
4 votes280 views3 answers
Copy table postgres
SQL
0 vote275 views1 answer
Add column in sql server ubuntu
SQL