Problem with case-insensitive queries

>Description: REGEXP and LIKE operators in SELECT statements will NOT do case-insensitive queries in VARCHAR() and BLOB text columns. E.g. SELECT * FROM article_database WHERE article_preview LIKE '%a%'; '%a%' LIKE 'What is a CPU?' -> 0

Fulltext and standard index, together?

Hi, We have this situation: select * from MyTable where match (col) against ("foo") limit 10; takes <1s, but: select * from MyTable where match (col) against ("foo") and col2 = 15; takes ~4s. col is a text field w/fulltext index, and col2 int unsigned w/standard index. So, what I was thinkin