Modules

ILIKE offers the same functionality as LIKE but disregards case sensitivity. This means 'Apple', 'apple', and 'APPLE' are all considered matches when searching for 'apple' using ILIKE.

With ILIKE you don't need to worry if there is any capital letter because ILIKE simply doesn't care. This is going to make your life easier!

Let's dive into a simple example with this table called books that have 2 columns: published date and title. We want to pull all the published dates that have the word 'the' in it. It can be in the middle, be with a capital T, we want them all!

How would you write this query?

Well, you will simply need to use ILIKE to make it happen!

SELECT published_date 
FROM books 
WHERE title ILIKE '%the%' 

And that's pretty much it!