Hi David,
| 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.
| 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.
Cheers,
Shashank
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
