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

15 votes200 views3 answers
Create table with primary key auto increment in sql
SQL
2 votes203 views1 answer
Oracle number to percentage
SQL
13 votes204 views2 answers
Check if value is null mysql
SQL
-1 vote205 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote160 views2 answers
Jupyter notebook connect to database
SQL
7 votes192 views3 answers
How to check table name in current database sql
SQL
0 vote191 views2 answers
Nosqlbooster query other collection
SQL
2 votes207 views1 answer
Oracle apex list connected users
SQL
0 vote213 views2 answers
Sql max count
SQL
0 vote217 views1 answer
How to take sum of column with same id in "JPQL?"
SQL