I have a requirement where I should use the value of table id and search it against another field:
So I was trying with LIKE or REGEXP but nothing is working :
Below is my query:
select name,street,shop from mtTABLE where Details REGEXP '%convert(id AS char)%';
but the result is coming a s zero !
Does somebody knows howto get around with this ?
Thanks in advance