postgresql like lowercase code example

Example 1: postgres like case insensitive

using ILIKE instead of LIKE

Example 2: postgres lowercase

SELECT lower('W3RESOURCE') AS "Upper to Lower";