making a query not case sensitive

[kehers]

how can i make a mysql query term not case sensitive..as in making the search for movies in the statement below not case sensitive

select *, match(url, title, comment) against ('movies') as score from dir where match(url, title, 
comment) against ('movies') and subdir='$in'

 

[Nematoth]

I thought sql queries weren't case sensitive by default...
Have you tested already and it doesn't work the way you expect it to?

Nematoth

http://www.etv.com.my

 

[johnwm]

Use a _ci (case insensitive) collation. See:

http://dev.mysql.com/doc/refman/4.1/en/charset-collate.html

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller