Questions tagged [against]
72 questions
0
votes
1 answer
Lot of filters search ¿match ... against?
I'm trying to make a filter search that matches like 12 variables got from forms, to 12 different columns in my database. Can this be done with the MATCH...AGAINST that I used to search just one thing, or I need other stuff?
Thank you ^^
user3897600
- 19
- 3
0
votes
0 answers
Sort MATCH AGAINST by different variable in database?
So I want to be able to change how results of a search query are listed. The top (sort by relevance) works, but when I try to order by a different variable in the same database, it doesn't work. Any suggestions? Please and thanks.
…
user3204846
- 11
- 4
0
votes
1 answer
Search words using MySQL fulltext
I have read so many query examples using
mySQL and fulltext indexes,
but I am still not able to make an apparently simple query.
I would like to search a list of words (ie. 'green, black, yellow, white, orange')
in text field of records, ordering…
user2102732
- 29
- 1
- 1
- 4
0
votes
1 answer
Mysql FullText, Match Against... and @ in search fields
select
count(distinct email_address)
from
users
WHERE
MATCH (email_address) AGAINST ('@rossi.it' );
Problem: the query search doesnt search for '@rossi.it' but only for 'rossi.it'.
How I should modify the query in order to have the "@"…
user3332779
- 1
- 1
0
votes
1 answer
MySQL fulltext against()
I am trying to create a search page with MySQL fulltext.
I have a search page with a textbox:
< FORM NAME ="form1" METHOD ="POST" ACTION ="catalog.php?action=">
I pass the user's input to another webpage (catalog.php) which…
Steve
0
votes
1 answer
FreeRDP CMAKE Error
Hello I am brand new to linux and i am trying to install FreeRDP. I keep getting this error:
/usr/bin/ld: /usr/local/ssl/lib/libcrypto.a(hmac.o): relocation R_X86_64_32 against `.rodata.str1.1' can not be used when making a shared object; recompile…
user3264108
- 1
- 1
0
votes
1 answer
Search XML feed's description against a keyword from database
I'm working on a project where I use XML feeds to get input. I have to filter the items which title and description that matches specific keywords. If an item contains smart phone in title or description, I have to add that item in database under…
Nagarajan
- 21
- 3
0
votes
2 answers
Mysql match against unknown column
I have a problem with this mysql query:
select * from tb1 as a
where (select count(*) from tb2 as b
where Match(b.column1) against(`a.id`) ) = '1'
Mysql has this error:
1054 - Unknown column 'a.id' in 'where clause'
So I want to get…
Wikunia
- 1,564
- 1
- 16
- 37
0
votes
1 answer
How to prevent concurrent streaming
I have written an app for a radio station, that is working well. If I click to go back to the desktop and click to activate the application again, it causes the app to stream again, resulting in 2 streams running concurrently.
Here is my…
emreturka
- 846
- 3
- 18
- 44
0
votes
2 answers
Mysql match against alternative
I need a search with a relevance algorithm and the database is mysql. I have to sort the results by date, if keyword is in title or not, number of apparitions of the keyword in the text and so on.
Match against doesn't give me that much control.
Bobby Tables
- 866
- 1
- 9
- 18
0
votes
2 answers
MySQL search with joins and match
I've got one table filled with information about companies (tblforetag) in Sweden, one table with provinces (tbllan) and one table with cities (tblstad). The cities are linked to the provinces with id numbers and the company table has a column for…
Christian Lundahl
- 2,000
- 3
- 18
- 29
-1
votes
1 answer
Match() AGAINST() in MYSQL
I am running the following query to search for strings containing '838' in the full_address column.
I am using Match, Against in MYSQl,
I am running following Query,
SELECT *
FROM fulladdress
WHERE MATCH (full_address) AGAINST ('838*' IN BOOLEAN…
Larry
- 71
- 5