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

3 votes350 views1 answer
Postgres select max value
SQL
0 vote313 views1 answer
Mysql_error replacement
SQL
0 vote301 views1 answer
MySQL FIND_IN_SET()
SQL
-1 vote326 views1 answer
How to switch user in mysql
SQL
2 votes330 views2 answers
Enable foreign key checks postgres
SQL
1 vote322 views1 answer
Psql datetime grather than
SQL
5 votes340 views1 answer
AND OR NOT operators sql
SQL
0 vote303 views1 answer
Procedures and functions in pl/sql
SQL
2 votes322 views1 answer
Mysql how to store lat,lng
SQL
10 votes322 views1 answer
Query to find object dependencies in oracle
SQL