Stack Overflow
Stack Overflow

Questions tagged [against]

72 questions
0
votes
1 answer

SQL FULLTEXT and AGAINST

I'm trying to fulltext search on a MariaDB database but for some reason i'm facing a problem and dont know what else to do. Imagine you have a database with some data on it. Will Smith En The Graham Norton Show Steve Smith Departs South Africa Tour…
Musikdoktor
  • 144
  • 2
  • 13
0
votes
2 answers

MySQL MATCH-AGAINST plural words?

I'd like to add a search to my site. I have a database of challenges from a video game. Each challenge has a title and description, I'd like to be able to search at least the description, but both if possible. Now, I've set the table up so that I…
HaLo2FrEeEk
  • 586
  • 7
  • 20
0
votes
1 answer

MYSQL FULLTEXT search for multi kewords

I have field called keywords and the stored info is a keywords separated with | For example: sky|Banana is good|apple|apple is red|sky is blue|green What i'm try to do is search in that field and find results that contains at least one of the…
user2203703
  • 1,955
  • 4
  • 22
  • 36
0
votes
0 answers

Java XML against XSD: The prefix "xs" for element "xs:schema" is not bound

I have trouble with my validation and I can't find any solutions. I am validating an XML file against this. XSD with my own Java 9 program which throws an Exception with the error message The prefix "xs" for element "xs:schema" is not…
epileptic
  • 27
  • 5
0
votes
1 answer

Order mysqls MATCH() AGAINST() relevancy with full math at the top

I ran into a problem using mysqls MATCH()...AGAINST() today. Because I guess it might be easier to adress my problem I created a small SQLFiddle. I fully understand, why "Foo Bar Foo" is more relevant then "Foo Bar" in the way this Select statment…
Christian Riese
  • 594
  • 1
  • 5
  • 18
0
votes
1 answer

MATCH AGAINST in MySQL don't work

I have a problem with FULLTEXT search in MySql. I create query: SELECT searchTag, MATCH (searchTag) AGAINST ('after party') as score FROM post WHERE MATCH (searchTag) AGAINST ('after party') ORDER BY score DESC Its result: 1. we,like,to,party…
user3633178
  • 61
  • 1
  • 12
0
votes
1 answer

Mysql Match Against Ranking

Im currently using a query for an autocomplete box with like. However I want to use the match, against which should be faster but I'm running against some issues with the sorting. I want to rank a query like this: [query] % [query]% % [query]%…
NLAnaconda
  • 1,534
  • 3
  • 14
  • 38
0
votes
0 answers

Insert different "glue" to a implode function based on a value preg_match

I'm performing a search query with MATCH and AGAINST in Bolean Mode, and i have the keywords stored in an ARRAY to show they like a TAGS, when I IMPLODE the array values to construct the query statement it works fine, but i want to preserve the…
EQrxJx
  • 135
  • 5
0
votes
2 answers

MySQL query to filter records containing any of the words in search string

I have to develop a simple search page that matches search string with field in MySQL table. Assume database table is 'records' and field in consideration is 'record_title'. Also say following are the 'record_titles' in rows. word1 word2 word1 word3…
GUIR
  • 71
  • 2
  • 7
0
votes
1 answer

Mysql fulltext search with Match and Against

this may be a very stupid question. However im new with mysql and hadn't that much experience. I wanted to create a fulltext search that searches throught multiple columns for a string. I found the way with Match and Against in the internet and…
stupidBoy
  • 11
0
votes
3 answers

Mysql MATCH AGAINST - IN BOOLEAN MODE problem

I need to find the following string: 'c++' My sql query look like this: SELECT * FROM shop_product WHERE MATCH(shop_product.name, shop_product.product_model, shop_product.keywords, shop_product.part_number, shop_product.upc,…
Emanuel
  • 6,622
  • 20
  • 58
  • 78
0
votes
0 answers

MySQL match() against() for multiple keyword for compare

MySQL match() against() for multiple keyword for compare this is my query : SELECT * FROM table WHERE MATCH(column) AGAINST('word') ORDER BY MATCH(column) AGAINST('word') DESC LIMIT 50; my database its look like that : id |…
bosslife
  • 13
  • 4
0
votes
1 answer

Match Against... SEMI-Literall

I want to do a match-against query in where all the words of the string must be necessary to be in the field, but it needs to accept mistakes or words uncomplete. My actual script is like this: $search= '+'.str_replace(" ","%…
Esteban Cazorla
  • 151
  • 12
0
votes
1 answer

MySQL Match Against giving 2 different results on 2 servers

I have a local dev version of a website that I'm coding a search function for and running into a problem where the the result I'm getting on my PC is different to the server. The problem is to do with there being a slash in the data. For example the…
Peter Rigby
  • 11
  • 4
0
votes
1 answer

MySQL Search Against a Keyword Table

I've been struggling to find the correct way to format my mysql expression to match against a related keyword table. The tables are set up as follows: photos: id,path,various exif data photos_to_tags: photos_id,photos_tags_id photo_tags:…
Jason Silver
  • 527
  • 7
  • 23
1 2 3
4
5