我想使用like关键字获取记录

I have the following query which is working fine, but I also want to get records using the like keyword. My query is as follows,I have the following query which is working fin