From: "Franz, Fa. PostDirekt MA" <[EMAIL PROTECTED]> KF> an Index wouldnt help much , because of the 'LIKE "%..." '. KF> If a wildcart is at the beginning of the search-string , an Index KF> cannot help much.
Ok as i thought, index text field is a bad thing ... KF> You have to think about why are there 3 fieds in your Table , KF> in which it is possible that the same kind of data can appear. KF> This structure forces you to query like this. KF> If you cannot get rid of this , it might be helpfull to make another field KF> for searching , where you concat Field 3,4 and 5 and just search on KF> this field. I can't create a new field, this will increase dramatically my table growth ... KF> I think it is better , if you change the way the data is inserted in your table , KF> that you can search more specific - without LIKE '%...' Hmm i've think about it but is quite difficult to find a better way. All the app is well, except this search ... Thanks David 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