MySQL - How to use fields in 'LIKE' operator

I want to do a 'select' in MySQL using the operator 'LIKE'.

But I do not want to use text as a comparison factor. I want to compare text between two fields in same table, like this:

SELECT field1,field2 FROM table WHERE field2 LIKE %field1开发者_运维百科% ;

Is it possible?

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

Yes, it is. You can use:

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