how to do a select on like values from multiple columns in sql

mysql, select, sql, sql-like

Solution

try this

SELECT genre AS result
FROM genres
WHERE genre LIKE '%ep%'
UNION
SELECT adjective_title AS result
FROM 
  adjectives
WHERE adjective_title LIKE '%ep%'

The union will eliminate duplicates in each query use UNION ALL for each.

Problem

I have two tables with columns: ``` Genres ID genre ``` and ``` Adjectives ID adjective_title ``` I need to do a select that returns the matching values from both tables columns with the `like` syntax. For example if ep was the value entered using `like` the results would look like: ``` result_column: -------------- epiphonic -- (from genres table) epic -- (from adjectives table) ``` etc . . . I'm pretty sure I need to use a subquery to return the results.

Original source