Stack Overflow
Stack Overflow

Questions tagged [exact-match]

208 questions
0
votes
1 answer

2 cells exact as another 2 cells in all rows

I have 2 cells of temperature and salinity. Sal Temp 34,9882 -1,4744 FALSE 34,9883 -0,0721 FALSE 34,9884 -0,8864 TRUE 34,9884 -0,8864 TRUE 34,9888 -1,5913 FALSE 34,9888 -1,5946 FALSE Here I have sorted…
Bala
  • 67
  • 1
  • 7
0
votes
2 answers

VIM regexp copy exact match

I would like to extract data from a document with VIM using regular expression but I only need the exact match and not the hole line. Basically just copy what :%s would replace. Simple example:…
Tharre
  • 111
  • 2
0
votes
2 answers

Can't get form to display mysql results

I'm fairly new to MySQL and PHP and have been reading books and watching tutorials and trying examples but I'm stuck on getting this search query to work. I have a simple search form:
user2447848
  • 289
  • 5
  • 17
0
votes
2 answers

MySQL Replace() unable to replace EXACT MATCH

Here's the issue. My query: UPDATE `table` SET `column` = replace(`column`,'123','456'); Is not going to work. Here's why: The numeric string '4123' now becomes '4456'. What I would like is for only EXACT matches (column value equals exactly '123')…
FurryWombat
  • 816
  • 2
  • 12
  • 28
0
votes
1 answer

PHP/MYSQL - Boolean Full-Text Searches - exact string operator ("") gives different result sets in Prepared Statement vs SQL Query

I am making an advanced search page on my website using PHP prepared statements to query a MySQL database MyISAM table using a Boolean Full-Text search. It is very much like the first section of the Advanced Search provided by Google and covers the…
Craig van Tonder
  • 7,497
  • 18
  • 64
  • 109
0
votes
0 answers

Weird behaviour matching exact phrases with sphinx

I am using the sphinx search engine. I need it to search for exact words in a field. Generally it works fine, but there are some weird anomalies. $this->sphinxclient->Query('@title "Alfa Romeo 159"~3', "indexads" ); I try this. If I correctly…
Borut Flis
  • 15,715
  • 30
  • 92
  • 119
0
votes
2 answers

Excel Function Help - Compare 2 Cells in Worksheet to 2 Cells in another worksheet, if they match, return value from a different column

I'm wondering if someone would be able to offer some advice on the best way to do this please: Data in Worksheet # 1 Col A | Col B | Col C Part-1 | 8 | 2 Part-2 | 7 | 7 Part-7 | 9 | 4 Part-8 | 2 | …
user2241640
  • 1
  • 1
  • 2
0
votes
1 answer

Find a exact word form column A within Text in Column B (MySQL)

i have 2 tables, and try to eleminate all entries in table 1 (multiple words per row) wich contain one of the entries in table 2. These words from table 2 can be somewhere in the strings of Table 1. it should find things like: 'house' in 'big house…
user2096557
  • 13
  • 3
0
votes
1 answer

solr exact match and indicator?

My documents have 5 fields, how can I config solr so that: 1)exact matches are on the top 2)indicator that there is exact match on the document additionally, is it possible to know which field the exact match happens? Thanks.
Henry
  • 384
  • 1
  • 9
  • 22
0
votes
1 answer

Is there a way with Solr to search fuzzy AND exact?

thank you for taking your time Problem I have a problem with searching records based on a fuzzy name search and an exact Regio search. This is what I have now: What I have now # :klantnaam is a param from a search-form @param =…
Carsten
  • 1,000
  • 8
  • 26
0
votes
4 answers

MySql - IN operator (with exact values)

Table "argument_user" +-------------+----------+ | argument | user_id | +-------------+----------+ | bike | 1 | | flower | 2 | | web | 1 | | web | 2 | | nature | 1 | | nature …
mtoninelli
  • 686
  • 1
  • 6
  • 21
0
votes
1 answer

SQL SELECT WHERE only exact array values

I have 2 tables: threads (thread_id) users (thread_id,user_id) Users create threads by inviting other users to be on a thread, so multiple users can be on the same thread. I am trying to prevent users from creating new threads that have the same…
Andrew Tibbetts
  • 2,874
  • 3
  • 23
  • 28
0
votes
1 answer

Algorithm and Design for developing a exact text system

We have millions of documents consisting of many paragraphs. The requirement is to develop a exact search system on top of this corpus. The search string will typically start from the beginning of a paragraph and may extend to two or more…
Sourabh sahay
  • 9
  • 1
-1
votes
2 answers

Need Regular Expression to fetch string data from array with exact match

I want to match and store string in an array using javascript and need regular expression for this. Other solution also appreciated. separated by '_' if only both matches in string those string from array should be retured only, no other match…
nubeCoder
  • 9
1 2 3
…
13
14