How to make it case-sensitive?

[Anon]

Hi!
I wanna do some fulltext search with the function match() in a fulltext indexed table of mysql,but the mysql reference mannaul say it case-insensitive!

for example:
mysql> CREATE TABLE articles (
-> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
-> title VARCHAR(200),
-> body TEXT,
-> FULLTEXT (title,body)
-> );

And then insert some data into it;

Then :
mysql> SELECT * FROM articles
-> WHERE MATCH (title,body) AGAINST ('database');

The mannual say that it case-insentitive~!
My problem is how to make it case-sentitive?
Just add 'BINARY' after 'title varchar(20) and 'body text'?

[Anon]

mmh, not sure, but try the REGEXP expression, there's a description inside the docs for it. Regular expression pattern would look like this: '/.searchstring./' [case sensitive] and '/.searchstring./i' [case insensitive]

Tommy.