What do you mean "varchar and text fields are not index"?
alter table mytable add index (myvarchar, mytext(100))
One last resort that may work for you is to try the regexp instead of
LIKE. The functionality of regexps for me has at best been
unpredictable, sometimes it is faster, sometimes at par with LIKEs.
So,
" where CONTENT like '%word1%'
or CONTENT like '%word2%'
or CONTENT like '%word3%' "
becomes,
" where CONTENT regexp 'word1|word2|word3' "
Cheers
Shanx
| Yep i do that but varchar and text fields aren't index so ...
|
| I'm also having a look to FULLTEXT index, but i think
| that the index will be really really big ... :(
|
Shashank Tripathi
www.shanx.com
Sql, query
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
