This is not clear enough, at least for me.
I’m not sure whether you want to get records like ‘cleaning’ or not.
If you want to get only records containing the word ‘lean’, then you should use something similar to this:
WHERE name like ‘lean %’
or name like ‘% lean’
or name like % lean %’
or name = ‘lean'</pre>
If you want to get all records containing ‘lean’ (including cleaning and others) then it is as simple as:
WHERE name like ‘%lean%'</pre>
If this is not what you meant, please provide the exact query that you are currently using, and some example data of what you are getting and what you would like to get.