MySQL Forums
Forum List  »  General

SQL Pattern Matching
Posted by: Joshua Grauman
Date: April 16, 2005 03:13PM

Hello all,

First off, thanks for all the good work. This is really a suggestion for future versions of MySQL. Due to the fact that SQL Pattern Matching is much much faster than RegExp pattern matching, it would be extremely useful if there was another operator which is a combination of the _ and the % for pattern matching. It would match 0-1 characters, rather than 1 (_) or 0-infinite (%). With this one simple operator, you could get any number of matches you wanted, ie for 3-5 (for example we'll call the new operator $) you would put ___$$. I haven't looked at MySQLs pattern matching source code, but since both % and _ are already implemented, I'm sure it would be really easy to add another operator that is similar to them both. Thanks.

Joshua Grauman

Options: ReplyQuote


Subject
Written By
Posted
SQL Pattern Matching
April 16, 2005 03:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.