case insensitive search.......how?

I have the value "Hello, I am a boy." in a field called "name" declared as VARCHAR(255)

I tried to do
SELECT * FROM table WHERE name LIKE '%hello%';

but it returns zero row.

and only
SELECT * FROM table WHERE name LIKE '%Hello%';

returns 1 row.

How to solve this?

--
Thanks and Regards,
Fung