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

1 vote143 views3 answers
Get all tables postgres
SQL
0 vote152 views1 answer
Laravel eloquent get generated sql
SQL
0 vote157 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote151 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote147 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
2 votes168 views1 answer
Sql skip the first row
SQL
1 vote138 views1 answer
Influxdb export to csv
SQL
0 vote109 views1 answer
Big query add table rows to another table
SQL
24 votes150 views5 answers
Sql server insert into select
SQL
0 vote158 views1 answer
Intellij idea add mysql connector
SQL