From: "Shashank Tripathi" <[EMAIL PROTECTED]> > | Why not regexp but this is not i mean, in fact > | " where CONTENT like '%word1%' > | > or CONTENT like '%word2%' > | > or CONTENT like '%word3%' " > | shoud be : > | " where CONTENT1 like '%word%' > | > or CONTENT2 like '%word%' > | > or CONTENT3 like '%word%' " > | So i'll be 3 regexp i think ... > > No, that'll be one regexp. That is the beauty of using regexp. Try it.
I'll have a look to doc and try it soon ... > > | Other big problem is why mysql locked all queries during > | executing this one ... > > > Agree on this one, this is a little unfortunate. But MySQL 4 should give > you row level locking, and well, using index on '%WORD%' as well. > Meanwhile, a full text index should be the only way out for you. Its big > but its worth it in your case. As soon as fulltext index will be built, i'll try some test and see what's is better ... Thanks David --------------------------------------------------------------------- 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
