How to write contains in a query?

[Rithvik2]

I have created a related list in the problem record like below screenshot...

It was working fine, but I need some modifications.. based on below logic.. I am comparing whether there is any similar short description is existed or not

but here I need to just check contains because everything will not match right?

and also one more point is.. based on that query I am getting self record under related list.. that I need to exclude.

[Sai Kumar B]

@Rithvik 

Try the below

current.addQuery('descriptionLIKE' , parent.description);

[Rithvik2]

@Sai Kumar 

One more query, please help..

Self record also showing in related list.. I need to exclude that as well..

[Sai Kumar B · Accepted solution]

Try with the below single query

current.addEncodedQuery('sys_id!='+parent.getValue('sys_id')+'^descriptionLIKE'+parent.description)