Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ben Seaman Optimising “Ends With” searches with REVERSE RE: Optimising “Ends With” searches with REVERSE
Varun.c
Valued Member
Points: 73
More actions
January 12, 2010 at 11:52 pm
#1102893
Nice Article.
I think you need to correct this query
from
SELECT NAME FROM TEST_TABLE WHERE NAME LIKE 'DI%'
To
SELECT NAME FROM TEST_TABLE WHERE NAME_REVERSED LIKE 'DI%'
Best,
Varun.C