Am 05.03.03 schrieb Thomas Spahni: > Some words like "Tetraeder" have the combination 'ae' and should be found > looking for LIKE '%ae%'; surprisingly this works:
Queries with "LIKE '%...'" can't use the index and work correct. Unfortunately this is no option for big tables. Ciao, Fabian Schmidt. -- TextTech GmbH Karl-Heine-Str. 99, 04229 Leipzig Tel. 0341 / 4912 245 --------------------------------------------------------------------- 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