MySQL - How to use fields in 'LIKE' operator

Question

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?

Odin · Accepted Answer · 2016-02-26 15:16:05Z

8

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

Odin

3,3882 gold badges21 silver badges19 bronze badges

answered Oct 18, 2010 at 17:12

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

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

Pablo Santa Cruz · Accepted Answer · 2010-10-18 17:13:16Z

0

Yes, it is. You can use:

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

answered Oct 18, 2010 at 17:13

Pablo Santa Cruz

182k33 gold badges250 silver badges300 bronze badges