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 vote134 views1 answer
Exclude last comma separated string mysql
SQL
10 votes130 views1 answer
Dba_dependencies
SQL
0 vote175 views1 answer
Stop psql server windows
SQL
1 vote141 views1 answer
Isnull sql server
SQL
0 vote140 views1 answer
Sql server user permissions and roles
SQL
3 votes85 views2 answers
Mysql sum with condition
SQL
0 vote185 views1 answer
Sqlalchemy _in array sqlite
SQL
0 vote145 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
1 vote130 views2 answers
How to check username in mysql command line
SQL
0 vote162 views1 answer
Import sql inside hide sql
SQL