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 vote224 views1 answer
C# sql transaction multiple connections
SQL
6 votes220 views3 answers
Mysql create database utf8
SQL
2 votes193 views1 answer
Mysql increment value by 1 in update
SQL
4 votes197 views1 answer
Mysql ip address
SQL
0 vote209 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote215 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
11 votes201 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote224 views2 answers
Jsonb
SQL
49 votes272 views6 answers
Alter table add column
SQL
2 votes312 views2 answers
How to DROP a table in mysql
SQL