MySQL - How to use fields in the "LIKE" statement

Question

I want to make a "choice" in MySQL using the "LIKE" operator.

But I do not want to use the text as a comparison factor. I want to compare text between two fields in one table, for example:

SELECT field1, field2 FROM table WHERE field2 LIKE% field1%;

Is it possible?

Answer 1

SELECT field1, field2 
FROM table 
WHERE field2 LIKE CONCAT('%', field1, '%');       

Answer 2

Yes it is. You can use:

SELECT field1,field2 FROM table WHERE field2 LIKE '%' + field1 '%' ;