Hello,

for the moment I'm trying to write searchengine kind-of-thing in PHP using MySQL, 
however MySQL tend to be very slow when searching.

My table is about 100 mb and the query is SELECT * FROM search WHERE search.content 
LIKE '%$keyword%' OR search.filnamn LIKE '%$keyword%'

I've tried setting INDEX but it didn't work out since I'm using BLOB-fields. Is there 
any other way than using INDEX?

Thanks,

Jome


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to