Questions tagged [match-against]
The match-against tag has no usage guidance.
match-against
144
questions
0
votes
0
answers
33
views
web aplication using php pdo fulltext search delivers result on ubuntu system but not on windows system; identical DB on both
The setting
Windows 11
Server-Version: 8.4.0 - MySQL Community Server - GPL
Apache/2.4.61 (Win64) PHP/8.3.8
Ubuntu
Server-Version: 10.3.39-MariaDB-0ubuntu0.20.04.2 - Ubuntu 20.04
Apache/2.4.41 (Ubuntu)...
- 359
0
votes
0
answers
35
views
MySQL fulltext search does not find existing record
I have found interesting issue within my MySQL fulltext search using MATCH function. Everything is fine except the records are incorrectly returned - only few of them.
Example:
There is a record in &...
- 69
0
votes
0
answers
34
views
mysql prepare query - WHERE MATCH, AGAINST is not working for exact phrase
I am attempting to run a match query of an exact phase. but my phrase is contained in a variable. I can accomplish it with the exact phrase as a constant but not as a variable.
I am running MySQL 8....
- 11
0
votes
0
answers
47
views
Using MATCH(FILTER) AGAINST with LIKE mysql
i will try to describe my question as simple as possible
i have a table called FILTERS with 2 columns 'Filter' and 'ID'
this table is populated like below example
|_. Filter |_. ID|
| shoes| 1|
| ...
- 11
0
votes
0
answers
53
views
Mysql MATCH AGAINST not working for latin characters - NOT issue with length of the word
SELECT first_name, last_name FROM users u WHERE MATCH(u.first_name, u.last_name) AGAINST ('+áééxcv*' IN BOOLEAN MODE);
I am trying to get the result where first_name of the record is áééxcv (latin ...
- 160
0
votes
0
answers
58
views
mysql MATCH AGAINST with LIMIT
everybody
I'm querying a huge table, trying to find the first 100 most recent record matching a town (in this example Venice): select id from table_name where MATCH(column_name) AGAINST (...
- 11
0
votes
2
answers
252
views
MySQL fulltext search over multiple columns
I've created a table with an full-text index over 2 columns:
CREATE TABLE players
(
id int NOT NULL,
first_name varchar(25) NOT NULL,
last_name varchar(25) NOT NULL,
team_id int NOT ...
1
vote
0
answers
66
views
Is there a better query to get most matched result
I'm trying to get most matched result using MATCH AGAINST.
My first query works correctly, but it using filesort.
And the second query also works well, but the query is duplicated and looks messy.
...
- 237
0
votes
1
answer
268
views
MySQL MATCH AGAINST not find results if an underscore is attached to the search term
I use full text indexing to find results faster and it works well except when the term i search for is attached to an underscore inside the database record.
My database records:
article.title
++++++++...
- 1
1
vote
2
answers
612
views
How to make an accent insensitive `MATCH() AGAINST()` sentence?
I have a table called products which has a varchar column called name encoded in latin1_swedish_ci.
I'm trying to make a search query in order to filter products by name using the MATCH() AGAINST() ...
- 2,293
0
votes
1
answer
919
views
MySQL - MATCH Keywords with Spaces AGAINST Large Text
We have a keyword database, for example:
1 | MySQL
2 | Database Developer
3 | Software Engineer
4 | Director of Development
And we need a fast way to scan a large set of text (say a resume in base ...
- 502
0
votes
2
answers
3k
views
MySql `MATCH AGAINST` and `LIKE` combination to search for special characters
For example, in database i have row with phrase DN-NP.
In input field i type DN- and want to find the row.
Here is example http://sqlfiddle.com/#!9/f9235a/4
Tried to use FULLTEXT index and MATCH ...
- 1,442
0
votes
0
answers
154
views
Using a mysql variable as parameter for AGAINST
I am fetching data from an excelsheet using LOAD DATA INFILE statement and trying to evaluate the results before saving to a database. I need to be able to pass one of the fields from the excel as a ...
- 62
-1
votes
3
answers
637
views
Can some explain me, my mysql match against why not working
i am use mysql full text on link column
but some time text match and some time its not working
i have example
http://sqlfiddle.com/#!9/470eb28/6
CREATE TABLE domains
(`name` varchar(300))
ENGINE=...
- 102
1
vote
1
answer
144
views
Use results of a mySQL SELECT as input of a MATCH AGAINST natural language query
I need to make a research by natural language on a mySQL table field taking as input the values of another table field. I tried something similar but, as I suspected, it was not correct:
SELECT id,...
- 525