English 中文(简体)
A. 按标题和作者分列的搜查书
原标题:Search book by title, and author

I got a table with columns: author firstname, author lastname, and booktitle Multiple users are inserting in the database, through an import, and I d like to avoid duplicates. So I m trying to do something like this: I have a record in the db: First Name: "Isaac" Last Name: "Assimov" Title: "I, Robot"

If the user tries to add it again, it would be basically a non-split-text (would not be split up into author firstname, author lastname, and booktitle) So it would basically look like this: "Isaac Asimov - I Robot" or "Asimov, Isaac - I Robot" or "I Robot by Isaac Asimov"

你们看到我正在走到哪里?

(我不能强迫用户将所有书本分为第一名作者、最后作者和书名,我甚至不喜欢强迫用户的想法,因为这样做不会过于方便用户)

将所有这些可能的图书数据假设与我在数据库中掌握的情况相比较的最佳方式是,不要再增加两本书。 我想到的是建议用户的可能性:“如果你试图增加这本书?” (一) 提问——相关问题,而不是相关国际交易日志的字句,就像插头一样。

我在思考一下

 soundex

甚至可能

 like

运营商,但迄今为止,一只 did子获得结果,一味希望。

最佳回答

你们可以比<条码>声音/difference更大幅度地实施比照法的算法:http://anastasiosyal.com/archive/2009/01/11/18.aspx” rel=“nofollow noreferer”>Beyond SoundEx - MS Fuzzysearchings in 服务器

您也可研究如何使用“搜索引擎”风格FREETEXT(。 :

Is a predicate used in a WHERE clause to search columns containing character-based data types for values that match the meaning and not just the exact wording of the words in the search condition

根据你的工作,你或许也可以利用国际交易日志的网络服务获得正常数据。

问题回答

暂无回答




相关问题
Find the closest time from a list of times

So, here s the scenario. I have a file with a created time, and I want to choose a time from a list of times that that file s created time is closest or equal too...what would be the best way to ...

PHP Comparison Operators and Data Types

I m currently working through O Reilly s "Programming PHP" and have come across this table titled "Type of comparison performed by the comparison operators": First Operand | Second ...

Loop Until Condition Reached, iPhone

I have a problem here... After a button is pressed I want a loop to run until a condition is reached: - (IBAction)buttonclick1 ... if ((value2ForIf - valueForIf) >= 3) { ... I would like a loop ...

nuSoap or Zend Soap? [closed]

I would like to know the differences between nusoap and ZendSoap, which is the best? what benefits and disadvantages of each? Anyone who has used both technologies could make this comparison? Thank ...

Logic for a file compare

I trying to write a programm for file compare. For example: file1 1 2 3 4 5 file2 1 2 @ 3 4 5 If I do it line by line, I get: 1 == 1; 2 == 2; 3 != @; 4 != 3; 5 != 4; != 5; But, the truth is ...

热门标签