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 vote419 views1 answer
Selecting specific day in colum sql
SQL
10 votes343 views2 answers
Forgot my mysql password mac
SQL
0 vote348 views1 answer
Mysql two joins
SQL
1 vote357 views1 answer
Sql not equal multiple columns
SQL
0 vote396 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote355 views2 answers
How to tun mysql on ubunto
SQL
0 vote374 views1 answer
Load data infile mariadb slow
SQL
0 vote343 views1 answer
Character count sql
SQL
0 vote350 views1 answer
Big table in mysql
SQL
6 votes353 views2 answers
Mysql get yesterday
SQL