postgres query case insensitive code example

Example: postgres like case insensitive

using ILIKE instead of LIKE