wildcard search on LARGE DB field "timeout"? help

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
rp
Forum Newbie
Posts: 21
Joined: Wed Nov 24, 2004 5:49 am

wildcard search on LARGE DB field "timeout"? help

Post by rp »

Hi Folks,

I have sorted one search aspect thanks to Kettle_drum but here is another search question.

I would like to search a DB table with over 20000 records, the field to be searched is a descriptive field at present a mediumblob, but can be turned into mediumtext or poss. varchar with 250 characters.

My search query i.e.

Code: Select all

<?php
Select * FROM (table) WHERE (Field) LIKE '%variable%'

?>
doesn't work, could this be a "timeout problem"?. If I use the same query structure on a different field in the table I get results, though the correct results the entry I use is not one that users of the DB will know (I get results using a refence number search rather than a keyword search)

Any suggestions? The search required is actually quiet simple, one keyword, against one table and only one filed in that table.

Also, if anybody knows, (a different search) how can I turn a series of key words (in one text box) into an array for a search that picks up any of the words entered.
e.g. search using "Help me know" and the search brings back all the references to Help, Me and Know.

Help much appreciated for a complete novice in this area
Post Reply