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. [EMAIL PROTECTED]
W. www.finlandexports.com

Reply via email to