Hello Paul, But RLIKE won't use indexes (even if they exist), so why RLIKE '^A' is better than LIKE 'A%', if LIKE which starts at the beginning of the string **will** use indexes?
Regards, Tom PD> Regular expression patterns (unlike SQL patterns) don't need to match the PD> entire string, so RLIKE '^A' is sufficient and more efficient because PD> it doesn't spend time trying to match anything other than the first PD> character. PD> As to the original question (below), that query looks like it should PD> work. Perhaps the problem lies elsewhere in the code that executes PD> the query. (It may be the query gets modified somehow. Without seeing PD> the context, it's hard to say.) --------------------------------------------------------------------- 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