opennms=# select * from categories where categoryname ilike '%pavlov%';
 categoryid | categoryname | categorydescription
------------+--------------+---------------------
         12 | pavlov       |
(1 row)

opennms=#