ilike comparison involving attributes and wildcards...

Поиск
Список
Период
Сортировка
От Spirit of Amiga
Тема ilike comparison involving attributes and wildcards...
Дата
Msg-id yfBB9.15265$2x4.1741066@news20.bellglobal.com
обсуждение исходный текст
Список 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



В списке pgsql-general по дате отправления: