Questions tagged [against]
72 questions
2
votes
2 answers
MATCH AGAINST in Doctrine
I found that if I use MATCH AGAINST in Doctrine with WHERE syntax does not replace the parameters passed. For example if I run the following code
$
q = Doctrine_Query::create()
->select('*')
->from('TourismUnit tu')
->where('FALSE');
if…
Emanuel
- 6,622
- 20
- 58
- 78
2
votes
1 answer
How to get the exact matched keyword in MySQL MATCH() AGAINST() search?
I am performing a search in mysql using MATCH() and AGAINST() function with multiple keyword. How to know which keyword matched for the search.
SELECT ... , MATCH(n.s_body_from_rss, n.s_full_body) AGAINST("LIST OF KEYWORDS' IN BOOLEAN MODE") AS…
Banty Roy
- 914
- 6
- 23
2
votes
0 answers
How to include column in against parameter for a match against query
I have a table of keywords that I need to match against another table of data and get the counts for the keywords that matched. Since the "against" parameter in the match against query does not take columns, only literal strings, is there any way to…
db1
- 2,939
- 3
- 15
- 13
2
votes
3 answers
Benchmarking tool
I'm unable to decide which is a better benchmarking tool-Is it apachebench tool or httperf?
Please help me to decide which one would be the most appropriate tool to be chosen for benchmarking the web application.
mamatha
- 49
- 5
1
vote
1 answer
How do I add another "AND" to a "MATCH AGAINST" query
I'm a newbie and I cannot get this query return any results.
How do I add AND paginas_taal = 'ned' to the query below?
Anyone has a clue?
SELECT *
FROM (
SELECT paginas_tekst AS Tekst, paginas_naam AS Naam, paginas_button AS Button, 'paginas' AS…
Hans
- 11
- 1
1
vote
1 answer
MySQL match against string containing percentage char
I am trying to find the value in db row, that include percentage sign.
For example, there is a value of a row "reduced by 10%".
I need to filter results that have "10%" in them, not just "10".
I was trying to
SELECT name, MATCH(name)…
Tim
- 782
- 1
- 5
- 11
1
vote
1 answer
How to eliminate bias against shorter rows in MATCH/AGAINST?
I am working on a simple search interface in a MyISAM table in MySQL, that is implementing the MATCH/AGAINST procedures.
It seems to work alright at first glance, but upon further inspection, it appears to have a bias towards shorter row length. I…
Ryan Ward Valverde
- 6,458
- 6
- 37
- 48
1
vote
1 answer
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, name, MATCH(name),
AGAINST
(
…
fede72bari
- 343
- 5
- 17
1
vote
1 answer
PHP MySQL show related items using tags
I want to show similar items using tags.
I have items table with itemid, itemname and itemtagids as columns. itemtagids has CSV tag ids.
Say in itemid 1, I have 3 tag ids 1,2,3 and in itemid 2 I have 4 tag ids 3,4,5,6 in itemid 3 I have 2 tag ids…
kb0000
- 444
- 3
- 6
- 18
1
vote
1 answer
SQL: MATCH AGAINST all elements in an array
I have an array of "tags" stored in a cookie. They are formatted as a series of words separated by ,'s. I'm trying to return all rows in a table where every "tag" of that array is found in the "search_tags" column.
I currently have:
$stmt =…
Van Zark
- 25
- 3
1
vote
1 answer
mysql fulltext search not working, even though entry exists and ft_min_word_len is set to 1
I have a mysql table and need to perform a fulltext search on it. However, even though the required data is in the table, fulltext search does not retrieve it.
Here is the query:
SELECT * from declensions_english where match(finite) against("did"…
AlexM
- 325
- 4
- 11
1
vote
2 answers
Mariadb query runs out of memory with use of match() against()
I have a very large table (around 50 GB) but with few columns:
CREATE TABLE my_table (
id BIGINT(20) NOT NULL AUTO_INCREMENT,
id_sec BIGINT(20) NULL,
full_name VARCHAR(100) NULL DEFAULT NULL,
PRIMARY KEY (id),
FULLTEXT INDEX…
Argos Canis
- 13
- 3
1
vote
1 answer
MATCH AGAINST in MySQL not showing records when search for string less than 4 chars
I am using FULLTEXT index on a column and when I use MATCH....AGAINST in boolean mode for any search term which is less than 4 characters in length then it doesn't return any records. And when I use LIKE then it does return records.
What could be…
Ali
- 1,801
- 6
- 43
- 58
1
vote
1 answer
Group concat with where match against in mysql
I'm working on a simple search function with SQL and got stuck. I use GROUP_CONCAT to put all keywords in a single row. The keywords are taken from categories.
Not all columns are in this example. I've stripped it down
SELECT
p.id as id,
p.title…
Jens Törnell
- 23,180
- 45
- 124
- 206
