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 vote216 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote224 views1 answer
Oracle DROP PROGRAM
SQL
-1 vote216 views2 answers
Get day in sql
SQL
2 votes226 views1 answer
Apex date today add days
SQL
0 vote241 views2 answers
How to take recent row without limit in mysql
SQL
0 vote222 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote197 views1 answer
Split a string with expression and get the last value of split sql
SQL
1 vote245 views1 answer
Round one decimal place mysql
SQL
-2 votes228 views2 answers
Sqlserver docker
SQL
1 vote215 views2 answers
Mysql trim whitespace
SQL