If you want to generalize the process to a n-set, a recursion method is clearly required. XSLT looks the best candidate to me to do this. I will tackle it when I find some time. Cheers Ignatius ____________________________________________ ----- Original Message ----- From: "Xepherys" <xepherys@xepherys.net> To: <php-db@lists.php.net> Sent: Thursday, October 10, 2002 8:26 AM Subject: MySQL REGEXP functionality... any way to make this easier? > Right now, a sample query I might have would be... > > SELECT * FROM ospd WHERE word REGEXP '^([a]?[p]?[e]?)$|^[p]?[a]?[e]?$|^[a > ]?[e]?[p]?$|^[p]?[e]?[a]?$|^[e]?[p]?[a]?$|^[e]?[a]?[p]?$'; > > > where basically I need to query every combination of a, p and e. This is a > pain, but for only three letter is not so bad. As you can see, this could > become unruly with larger numbers of letters. Each instance of a letter can > only occur once. However, a letter may be duplicated and used once for each > instance. Hence the statement steps through... it could also be something > like... > > SELECT * FROM ospd WHERE word REGEXP > '^[a]?[a]?[e]?$|^[a]?[e]?[a]?$||^[e]?[a]?[a]?$'; > > more easily written because one letter is used twice and can occure once for > each instance. Please let me know if you have any ideas. > > > Jesse > jesse.williams@xepherys.net > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
