Tilted Forum Project Discussion Community  

Go Back   Tilted Forum Project Discussion Community > Interests > Tilted Technology


 
 
LinkBack Thread Tools
Old 04-14-2004, 02:34 PM   #1 (permalink)
Insane
 
Wildcards, search engines, and more...

If you search a column in a database for "6648-8%", and the column contains a record "6648-84U", that record will match, and the row will be returned.

This much I know.

How can I do it the other way? I want to be able to specify that a record should match "6648-8%", where that is actually the search string.

I've tried simply putting that in as the record...while that would make sense, it doesn't work.

I'm having very little luck with Google here, mainly because I'm unsure what to search for.

MPEDrummer
__________________
My sig can beat up your honor student.
mpedrummer2 is offline  
Old 04-14-2004, 03:39 PM   #2 (permalink)
Upright
 
Location: Boulder, Colorado
Try preceding the % sign with a backslash; ( \% ) It's the standard way to show that you want to literaly display ("escape") a special character.

Cheers.
__________________
/K
ketamine is offline  
Old 04-14-2004, 07:47 PM   #3 (permalink)
Insane
 
Hmm...perhaps I'm unclear...

I want the user to be able to search for the specific 6648-84U and have a record MATCH 6648-8%. So the user could enter any specific model number, and match the broader information as well.

Without entering everything as individual keywords.

MPEDrummer
__________________
My sig can beat up your honor student.
mpedrummer2 is offline  
Old 04-14-2004, 08:23 PM   #4 (permalink)
I am Winter Born
 
Pragma's Avatar
 
Location: Alexandria, VA
Perhaps parse the input before passing it to the search, to chop off the last character and have it be replaced with a wildcard (a little string manipulation), and then pass that to the search.

Could work.
__________________
Eat antimatter, Posleen-boy!
Pragma is offline  
Old 04-14-2004, 11:47 PM   #5 (permalink)
Devils Cabana Boy
 
Dilbert1234567's Avatar
 
Location: Central Coast CA
brakets? quotes?

its character 37 if you can input a character.
__________________
Donate Blood!

"Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen
Dilbert1234567 is offline  
Old 04-15-2004, 01:48 AM   #6 (permalink)
Crazy
 
Location: San Diego, CA
Quote:
Originally posted by mpedrummer2
Hmm...perhaps I'm unclear...

I want the user to be able to search for the specific 6648-84U and have a record MATCH 6648-8%. So the user could enter any specific model number, and match the broader information as well.

Without entering everything as individual keywords.

MPEDrummer
Well, here you get the problem of not knowing where to cut off the search and put in the %. If there's a clear way to know where to cut it, then just chop that bit off and add in the %. For example, if you always want to cut off the last 2 digits, or if you always cut starting from the last number, etc. If there isn't a clear way to cut it, you'd need to specify specific rules depending on the type of id. This could be very, very tedious. It might be better to just leave that kind of searching to the user - they probably know better than the program anyway.
__________________
"Don't believe everything you read on the internet. Except this. Well, including this, I suppose." -- Douglas Adams
Rangsk is offline  
Old 04-15-2004, 05:22 AM   #7 (permalink)
I am Winter Born
 
Pragma's Avatar
 
Location: Alexandria, VA
It's also possible to run it through a regex, ie:

If it matches the pattern of dddd-dd[.], then chop off the last digit and replace it with a %, otherwise match it with a different pattern.
__________________
Eat antimatter, Posleen-boy!
Pragma is offline  
Old 04-15-2004, 07:31 AM   #8 (permalink)
Insane
 
Quote:
Originally posted by Pragma
It's also possible to run it through a regex, ie:

If it matches the pattern of dddd-dd[.], then chop off the last digit and replace it with a %, otherwise match it with a different pattern.
The problem there, though, is that then information specific to the 6648-84T would be returned.

I think you're on the right track.

I'm going to play with this a bit:
Code:
SELECT books FROM info WHERE keyword IN('6648-84U','6648-84\*', '6648-8\*\*', etc)
and we'll go from there.

MPEDrummer
__________________
My sig can beat up your honor student.
mpedrummer2 is offline  
Old 04-15-2004, 08:35 AM   #9 (permalink)
Crazy
 
Location: San Diego, CA
Quote:
Originally posted by mpedrummer2
I'm going to play with this a bit:
Code:
SELECT books FROM info WHERE keyword IN('6648-84U','6648-84\*', '6648-8\*\*', etc)
and we'll go from there.

MPEDrummer
Wouldn't this return EVERY book, since you'd eventually get to all *s?
__________________
"Don't believe everything you read on the internet. Except this. Well, including this, I suppose." -- Douglas Adams
Rangsk is offline  
Old 04-15-2004, 09:23 AM   #10 (permalink)
Insane
 
Nope. What I'd be doing is backwards...I'd be searching for the LITERAL *, not * as a wildcard. Then, for entries that will apply to all of a series, such as the entire 800 series 6648, I could make the model keyword 6648-8**.

This results in 1 single keyword that matches all 1296 possible 2-alphanumeric-character combinations that could be after the 8.
__________________
My sig can beat up your honor student.
mpedrummer2 is offline  
Old 04-15-2004, 10:28 AM   #11 (permalink)
Crazy
 
Location: San Diego, CA
Maybe I'm still confused about what your problem is, but since you seem to have it solved I won't worry about it.
__________________
"Don't believe everything you read on the internet. Except this. Well, including this, I suppose." -- Douglas Adams
Rangsk is offline  
Old 04-15-2004, 11:36 AM   #12 (permalink)
Wehret Den Anfängen!
 
Location: Ontario, Canada
If you want a "fast" solution, try backreferences.

Ie, in the 6648-84U entry there is a reference to 6648-8% and all other wildcard entries that match it.

Keep a table of all "wildcard" entries in the db, like 6648-8%.

If someone enters something not in the DB, you can either decide you 'should' fail, or you can decide to do a search only through the "wildcard" entries.

The second use of the "wildcard"-only table is when you add a new normal entry to the DB. You'll have to check it against all existing "wildcard" entries and insert the correct backreferences.

When you add a "wildcard" entry, you can simply search for it, and insert the required backreferences.

This would allow for "wildcard" entries like
66%-8%U
which none of the other proposals deal with reasonably.

(I assume you know how to have an arbitrary number of backreferences in a db: use a linked list)
__________________
Last edited by JHVH : 10-29-4004 BC at 09:00 PM. Reason: Time for a rest.
Yakk is offline  
Old 06-08-2004, 08:57 PM   #13 (permalink)
Insane
 
Well, here I am, day late and a dollar short, but I figured it out.

The SQL function REGEXP can accept a stored column as either argument. By using the stored column as the regular expression, and not what I'm matching against, it's a snap

MPEDrummer
__________________
My sig can beat up your honor student.
mpedrummer2 is offline  
 

Tags
engines, search, wildcards


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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -8. The time now is 11:14 PM.

Tilted Forum Project

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2
© 2002-2012 Tilted Forum Project

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76