From: "Mikhail Entaltsev" <[EMAIL PROTECTED]> > As I understand... > After removing "Field5 LIKE '%John'" condition the query works much faster. Nop, sorry i'm not clear, the query works mush slower ...
> But it is different query... :) > I mean that queries return different results. Yep ... > On other hand you can't change type of Field5 because you have a row with > 51723 symbols in Filed5. :( I know that and that's a problem ... > So... > question: Do you actually need this condition? ;) I need it yes, but i'm thinking about doing 2 or 3 queries or modify some code of my app about this search ... Thanks David --------------------------------------------------------------------- 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