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 vote215 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote228 views1 answer
Psql generate id in existing database
SQL
1 vote216 views1 answer
Does insert into overwrite sql
SQL
2 votes229 views1 answer
Postgresql change value in column
SQL
0 vote308 views1 answer
Restart serial number for postgres
SQL
11 votes225 views2 answers
How to import mysql database command line
SQL
2 votes238 views2 answers
Postgresql get table names
SQL
1 vote241 views1 answer
Postgres see sequence current state
SQL
0 vote234 views1 answer
Query builder doctrien return sql
SQL
9 votes213 views2 answers
Convert data type in sql
SQL