Using regex with LIKE clause

Question

WHen i hit the follwing query I get 1 row

SELECT * FROM servers WHERE Node='abc_deeh32q6610007'

However when I hit the following query 0 rows are selected

SELECT * FROM servers WHERE Node LIKE '%_deeh32q6610007'

I am using MySQL DB.

can you pls share the table design so that i can check through fiddle — Hari17
– Hari17, Commented Mar 14, 2018 at 6:33
You want create table query? you can create a table named servers with just 1 column Node of type var — codec
– codec, Commented Mar 14, 2018 at 6:57

Jay Shankar Gupta · Accepted Answer · 2018-03-14 06:31:43Z

3

SELECT * FROM servers WHERE Node LIKE '%\_deeh32q6610007'

answered Mar 14, 2018 at 6:31

Jay Shankar Gupta

6,1281 gold badge14 silver badges31 bronze badges

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

1 Comment

Even this returned 0 rows