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%'
?>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