ilike comparison involving attributes and wildcards... - Mailing list pgsql-general

The query below seems like a lame hack to me:

SELECT some_column
    FROM some_table
    WHERE '$some_string_var' ILIKE '%' || some_column || '%';

Is there a more elegant way of comparing a value with a wildcarded column?

TIA,

SoA