[datricker]

For what its worth I don't find manafort in the Senates Lobbying Database.

Okay so he a foreign lobbyist but he not registering his lobbying activity there either.

This isn't going to work out well for Paul - he looking like he pretty clearly wasn't following the law. I don't know much about the foreign lobbying stuff but my domestic data goes back to late 1998 up to yesterday. Perhaps he had a lower level lobbyist file as the lobbyist of record but for 20 years ... umm bad Paul bad looks like your ass is grass.

SELECT name FROM lobbyist WHERE name ILIKE '%manafort%';
name ------ (0 rows)

versus lets say Tony Podesta

SELECT name FROM lobbyist WHERE name ILIKE '%podesta%';
name ------------------
podesta, anthony
podesta, anthony
podesta, daniel
podesta, heather
podesta, heather
podesta, heather
podesta, john
podesta, john
podesta, john
podesta, heather
podesta, anthony
podesta, heath
(12 rows)

[bankwalker]

What version of SQL uses “ILIKE” and what does it do? Thanks.