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. |
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. |
04-14-2004, 08:23 PM | #4 (permalink) |
I am Winter Born
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! |
04-15-2004, 01:48 AM | #6 (permalink) | |
Crazy
Location: San Diego, CA
|
Quote:
__________________
"Don't believe everything you read on the internet. Except this. Well, including this, I suppose." -- Douglas Adams |
|
04-15-2004, 05:22 AM | #7 (permalink) |
I am Winter Born
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! |
04-15-2004, 07:31 AM | #8 (permalink) | |
Insane
|
Quote:
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) MPEDrummer
__________________
My sig can beat up your honor student. |
|
04-15-2004, 08:35 AM | #9 (permalink) | |
Crazy
Location: San Diego, CA
|
Quote:
__________________
"Don't believe everything you read on the internet. Except this. Well, including this, I suppose." -- Douglas Adams |
|
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. |
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 |
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. |
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. |
Tags |
engines, search, wildcards |
|
|