[sql] regex

[Yennie at aol.com]

Robert,

It looks like there is maybe a bug with the SQL you posted, but is there any 
reason not to use an index-by-words index if you only want to match whole 
words?

Then you could just use this query which I'm fairly sure will work:

SELECT r_fna,r_mna,r_lna,r_ema,r_rid
FROM registration1,registration2b
WHERE u_rid = r_rid and r_rid > 0 and
u_mtch = 'robert' and u_mtch = 'brenstein'

You'll need to set u_mtch index to index-by-words for this, so if you need an 
ordinary index also for that field, you'll need to use a method field.

Brian