dbTalk Databases Forums  

Database query can't start with *

comp.databases comp.databases


Discuss Database query can't start with * in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mike
 
Posts: n/a

Default Database query can't start with * - 03-19-2007 , 04:55 AM






I downloaded regain. It indexes your system and allows searching
in a fashion much like google. Jakarta Lucene engine??

My first search term was "mike"...zero hits.
Second search was "mike*"...470 hits
My third search was "*mike*...error message: search string can't start
with *

Some googling turned up that this is a common database problem
across various databases. Solutions started with doubling the size
of your database and doing convoluted searches and went downhill from
there.

Ok, I'm a dummy. My third attempt to search hits a brick wall.
I can't be the only person on the planet who thinks you oughta be able
to search
for a record ending in "string" e.g. "*string"

Is there a rational workaround for this?
And just for curiosity, why ain't this been fixed decades ago?
Seems like an obvious need????

Thanks, mike

--
Return address is VALID!
Bunch-O-Stuff Forsale Here:
http://nm7u.tripod.com/homepage/sale.html

Reply With Quote
  #2  
Old   
--CELKO--
 
Posts: n/a

Default Re: Database query can't start with * - 03-19-2007 , 07:11 AM






The % sign is the "wild card" symbol in SQL, not the *, but that means
it should have been read as a character .. weid.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.