Hi to all of you!
The following query takes more than half an our to execute. I don't think
that is normal. Most time takes "copying to tmp table".
SELECT DISTINCT
Formular.titel AS formularTitel,
Formular.id AS formularId,
Anbieter.id AS anbieterId,
Anbieter.anbieterName AS anbieterName
FROM
Formular,
Anbieter
WHERE
Formular.anbieter_id=Anbieter.id
AND (
( Formular.titel LIKE '%köln%' OR Formular.schluesselwoerter LIKE '%köln%'
OR Anbieter.anbieterName LIKE '%köln%' )
AND
( Formular.titel NOT LIKE '%gew%' AND Formular.schluesselwoerter NOT LIKE
'%gew%' AND Anbieter.anbieterName NOT LIKE '%gew%' )
)
I hope someone can help me.
Thanks a lot,
Benne
--
Benjamin Boksa
[EMAIL PROTECTED]
side by site GmbH & Co. KG
Druckgestaltung & Webdesign
Barbarastr. 3-9 (Block 6)
D-50735 Koeln
Telefon: +49 221 2790964
Telefax: +49 221 2790965
http://www.sidebysite.de/
---------------------------------------------------------------------
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
