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

7 votes146 views2 answers
Mysql get year from date
SQL
0 vote136 views1 answer
Flask sqlalchemy update row
SQL
2 votes190 views1 answer
Creating a view SQL
SQL
1 vote156 views1 answer
Full sql mode
SQL
0 vote135 views1 answer
Sqldf change user
SQL
46 votes219 views4 answers
Create column sql
SQL
13 votes160 views1 answer
Sql join 3 tables on id
SQL
-1 vote177 views1 answer
Sql show custom constraints
SQL
0 vote155 views1 answer
Mysql join column order By and group By
SQL
3 votes136 views2 answers
Find the median in sql
SQL