Open

How to escape special charaters like % on ilike in rails

How to escape the special characters such as %, & using ilike in rails

As i'm getting error when i enter special characters like %,& in search box , as my query was this book.where("book.name ilike ?", "%#{options[:book_name]}%")

How to escape the special characters using ilike?