how achive numeric value search in full text search?
like condition :
product.product_name like '%7 up%'
output here
fulltext search :
MATCH(product.product_name) AGAINST('+7+up' IN BOOLEAN MODE)
or
MATCH(product.product_name) AGAINST('"7 up"' IN BOOLEAN MODE)
How come above both queries are not returning any result ?
mysql full-text-search
edited Jan 2 at 17:47
Bill Karwin
382k64519676
asked Jan 2 at 17:02
jayaprakash kjayaprakash k
63
add a comment |
like condition :
product.product_name like '%7 up%'
output here
fulltext search :
MATCH(product.product_name) AGAINST('+7+up' IN BOOLEAN MODE)
or
MATCH(product.product_name) AGAINST('"7 up"' IN BOOLEAN MODE)
How come above both queries are not returning any result ?
mysql full-text-search
edited Jan 2 at 17:47
Bill Karwin
382k64519676
asked Jan 2 at 17:02
jayaprakash kjayaprakash k
63
That doesn't look like a numeric search to me.
– Robert Harvey♦
Jan 2 at 17:04
first numeric then it's letter
– jayaprakash k
Jan 2 at 17:06
add a comment |
like condition :
product.product_name like '%7 up%'
output here
fulltext search :
MATCH(product.product_name) AGAINST('+7+up' IN BOOLEAN MODE)
or
MATCH(product.product_name) AGAINST('"7 up"' IN BOOLEAN MODE)
How come above both queries are not returning any result ?
mysql full-text-search
edited Jan 2 at 17:47
Bill Karwin
382k64519676
asked Jan 2 at 17:02
jayaprakash kjayaprakash k
63
like condition :
product.product_name like '%7 up%'
output here
fulltext search :
MATCH(product.product_name) AGAINST('+7+up' IN BOOLEAN MODE)
or
MATCH(product.product_name) AGAINST('"7 up"' IN BOOLEAN MODE)
How come above both queries are not returning any result ?
mysql full-text-search
mysql full-text-search
edited Jan 2 at 17:47
Bill Karwin
382k64519676
asked Jan 2 at 17:02
jayaprakash kjayaprakash k
63
edited Jan 2 at 17:47
Bill Karwin
382k64519676
asked Jan 2 at 17:02
jayaprakash kjayaprakash k
63
edited Jan 2 at 17:47
Bill Karwin
382k64519676
edited Jan 2 at 17:47
Bill Karwin
382k64519676
edited Jan 2 at 17:47
Bill Karwin
382k64519676
382k64519676
asked Jan 2 at 17:02
jayaprakash kjayaprakash k
63
asked Jan 2 at 17:02
jayaprakash kjayaprakash k
63
asked Jan 2 at 17:02
jayaprakash kjayaprakash k
63
63
That doesn't look like a numeric search to me.
– Robert Harvey♦
Jan 2 at 17:04
first numeric then it's letter
– jayaprakash k
Jan 2 at 17:06
add a comment |
That doesn't look like a numeric search to me.
– Robert Harvey♦
Jan 2 at 17:04
first numeric then it's letter
– jayaprakash k
Jan 2 at 17:06
That doesn't look like a numeric search to me.
– Robert Harvey♦
Jan 2 at 17:04
That doesn't look like a numeric search to me.
– Robert Harvey♦
Jan 2 at 17:04
first numeric then it's letter
– jayaprakash k
Jan 2 at 17:06
first numeric then it's letter
– jayaprakash k
Jan 2 at 17:06
add a comment |
1 Answer
1
active
oldest
votes
First expression looks good, however you should be aware that, by default, MySQL ignores words shorter than three characters. This is controlled by parameter innodb_ft_min_token_size. It is possible to change that parameter but it requires to restart the server and rebuild your FULLTEXT indexes ; this is not recommended by mysql. See this document for more details on Fulltext tuning.
Second expression, with enclosing double quotes, will try to perform a litteral match : this does not seem to be what you need.
To make it short : given what you are searching for, you are probably better off using LIKE.
answered Jan 2 at 17:11
GMBGMB
17.8k31028
not working with this query MATCH(product.product_name) AGAINST('+7 +up' IN BOOLEAN MODE) it's giving no result found if i'm try with this like condition product.product_name like '%7 up%' it's giving result
– jayaprakash k
Jan 2 at 17:14
@jayaprakashk : I changed my answer, please check
– GMB
Jan 2 at 21:56
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54010307%2fhow-achive-numeric-value-search-in-full-text-search%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
First expression looks good, however you should be aware that, by default, MySQL ignores words shorter than three characters. This is controlled by parameter innodb_ft_min_token_size. It is possible to change that parameter but it requires to restart the server and rebuild your FULLTEXT indexes ; this is not recommended by mysql. See this document for more details on Fulltext tuning.
Second expression, with enclosing double quotes, will try to perform a litteral match : this does not seem to be what you need.
To make it short : given what you are searching for, you are probably better off using LIKE.
answered Jan 2 at 17:11
GMBGMB
17.8k31028
not working with this query MATCH(product.product_name) AGAINST('+7 +up' IN BOOLEAN MODE) it's giving no result found if i'm try with this like condition product.product_name like '%7 up%' it's giving result
– jayaprakash k
Jan 2 at 17:14
@jayaprakashk : I changed my answer, please check
– GMB
Jan 2 at 21:56
add a comment |
First expression looks good, however you should be aware that, by default, MySQL ignores words shorter than three characters. This is controlled by parameter innodb_ft_min_token_size. It is possible to change that parameter but it requires to restart the server and rebuild your FULLTEXT indexes ; this is not recommended by mysql. See this document for more details on Fulltext tuning.
Second expression, with enclosing double quotes, will try to perform a litteral match : this does not seem to be what you need.
To make it short : given what you are searching for, you are probably better off using LIKE.
answered Jan 2 at 17:11
GMBGMB
17.8k31028
not working with this query MATCH(product.product_name) AGAINST('+7 +up' IN BOOLEAN MODE) it's giving no result found if i'm try with this like condition product.product_name like '%7 up%' it's giving result
– jayaprakash k
Jan 2 at 17:14
@jayaprakashk : I changed my answer, please check
– GMB
Jan 2 at 21:56
add a comment |
First expression looks good, however you should be aware that, by default, MySQL ignores words shorter than three characters. This is controlled by parameter innodb_ft_min_token_size. It is possible to change that parameter but it requires to restart the server and rebuild your FULLTEXT indexes ; this is not recommended by mysql. See this document for more details on Fulltext tuning.
Second expression, with enclosing double quotes, will try to perform a litteral match : this does not seem to be what you need.
To make it short : given what you are searching for, you are probably better off using LIKE.
answered Jan 2 at 17:11
GMBGMB
17.8k31028
First expression looks good, however you should be aware that, by default, MySQL ignores words shorter than three characters. This is controlled by parameter innodb_ft_min_token_size. It is possible to change that parameter but it requires to restart the server and rebuild your FULLTEXT indexes ; this is not recommended by mysql. See this document for more details on Fulltext tuning.
Second expression, with enclosing double quotes, will try to perform a litteral match : this does not seem to be what you need.
To make it short : given what you are searching for, you are probably better off using LIKE.
answered Jan 2 at 17:11
GMBGMB
17.8k31028
edited Jan 3 at 9:15
answered Jan 2 at 17:11
GMBGMB
17.8k31028
answered Jan 2 at 17:11
GMBGMB
17.8k31028
answered Jan 2 at 17:11
GMBGMB
17.8k31028
17.8k31028
not working with this query MATCH(product.product_name) AGAINST('+7 +up' IN BOOLEAN MODE) it's giving no result found if i'm try with this like condition product.product_name like '%7 up%' it's giving result
– jayaprakash k
Jan 2 at 17:14
@jayaprakashk : I changed my answer, please check
– GMB
Jan 2 at 21:56
add a comment |
not working with this query MATCH(product.product_name) AGAINST('+7 +up' IN BOOLEAN MODE) it's giving no result found if i'm try with this like condition product.product_name like '%7 up%' it's giving result
– jayaprakash k
Jan 2 at 17:14
@jayaprakashk : I changed my answer, please check
– GMB
Jan 2 at 21:56
not working with this query MATCH(product.product_name) AGAINST('+7 +up' IN BOOLEAN MODE) it's giving no result found if i'm try with this like condition product.product_name like '%7 up%' it's giving result
– jayaprakash k
Jan 2 at 17:14
not working with this query MATCH(product.product_name) AGAINST('+7 +up' IN BOOLEAN MODE) it's giving no result found if i'm try with this like condition product.product_name like '%7 up%' it's giving result
– jayaprakash k
Jan 2 at 17:14
@jayaprakashk : I changed my answer, please check
– GMB
Jan 2 at 21:56
@jayaprakashk : I changed my answer, please check
– GMB
Jan 2 at 21:56
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54010307%2fhow-achive-numeric-value-search-in-full-text-search%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
That doesn't look like a numeric search to me.
– Robert Harvey♦
Jan 2 at 17:04
first numeric then it's letter
– jayaprakash k
Jan 2 at 17:06