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 vote282 views1 answer
Add column not null with default value postgres
SQL
1 vote257 views1 answer
Mysql get last insert id
SQL
0 vote736 views2 answers
Zsh: command not found: mysq
SQL
-1 vote276 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote283 views2 answers
T SQl Checking Your Username
SQL
1 vote338 views1 answer
Postgresql if 0 then 1
SQL
1 vote296 views1 answer
Show all event schedular on mysql
SQL
0 vote301 views1 answer
SQL Query to delete all the tables in a database
SQL
1 vote300 views1 answer
Sqlalchemy order_by
SQL
0 vote299 views2 answers
Jsonb
SQL