Forum Moderators: open

Message Too Old, No Replies

MySQL Fulltext fuction case sensitive?

mysql fulltext case-sensitive

         

neteagle

2:52 am on May 7, 2006 (gmt 0)

10+ Year Member



I made a fulltext search on my database. The SQL query is "select * from product match(product_name) against ('Tree')". I got the results "Trunk of an Old Yew Tree,Tree Trunks with Ivy,Rocks with Oak Tree...".But when I change the search word "Tree" to "tree",I got no result.
Fulltext search function seems to be no case sensitive,so how do I fix this problem?

txbakers

5:14 pm on May 8, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



SELECT * from table where UPPER(tree) = UPPER(Tree)

will work.