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

4 votes360 views3 answers
Is not null sql
SQL
1 vote322 views1 answer
Foreign key constraint in ms sql
SQL
1 vote368 views1 answer
Mysql curdate between two dates
SQL
18 votes327 views4 answers
Foreign key mySql
SQL
1 vote349 views1 answer
Python clean sql string
SQL
0 vote369 views1 answer
Drop database using terminal postgres
SQL
8 votes387 views2 answers
How to fetch data from database without last column
SQL
1 vote404 views1 answer
Sql first day quarter
SQL
5 votes326 views1 answer
Mysql select greater than yesterday
SQL
8 votes358 views1 answer
Oracle create datafile
SQL