SQL how to find records with same values ​​of different columns?

Question

SQL

The table has keyword and title fields
How to execute a query that will find records whose keyword field value is equal to the title field value

Answer 1

SELECT * FROM table WHERE keyword = title is a bit too obvious.
Maybe you need to find different posts that have the same keyword and title?
SELECT * FROM table t1, table t2 WHERE t1.keyword = t2.title, something like this.