MySQL query length
| From: | Niklas Lampén | Date: | Tue, 28 Aug 2001 06:51:03 +0000 |
| Subject: | MySQL query length | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-64735@lists.php.net to get a copy of this message | ||
Can it cause any problems if mySQL query is very long? I have to compare
many words to many fields in my DB and I've done it like
"....Field LIKE '%searchword%' || Field LIKE '%searchword%' || Field LIKE
'%searchword%'.....". Query is build by a function, so I don't know the
exact length but it is VERY long. I also have to compare several words to
one field so I've done many of those "Field LIKE '%blah%'" for those too.
Is there any smarter way to do this?
Niklas Lampén
Internet Developer
PubliCo Oy
Ruoholahdenkatu 8 A
FIN-00180 HELSINKI
P. +358 - 9 - 6866 2541
F. +358 - 9 - 685 2940
E. niklas.lampen@publico.fi
W. www.finlandexports.com