PHP/MySQL case question?

[Timbuktu]

in my search engine script, i have the "select * from table1 where column1 like %$_POST[search]% or column2 like etc". But when i conduct the search, things appear to be case sensitive. For example, when searching for date, e.g. June, if i typed june, i couldn't find anything, only if i typed June.

i could use the "strtoupper" function like:

$_POST[search]=strtoupper($_POST[search]); before the query above, and then search all in CAPS?

any other solutions which will make things case insensitive?
or put differently: how do you make a query result case insensitive?

[Palash]

just try this code

"select * from table1 where column1 like '%$_POST[search]%'"

bsc your query is string not integer thats why your query not working properly.
Thanks