mysql - match against query numeric value not found -
i have problem match against query. getting 0 result in query when pass onlu numeric value here query :
select * tbl1 match(
sub_name) against('+praga*' in boolean mode) , match(
sub_address) against('+203*' in boolean mode)
// result 0 row found
select * tbl1 match(
sub_name) against('+praga*' in boolean mode) , match(
sub_address) against('+203 s*' in boolean mode)
// result found
when use numeric in (203) 0 result use char 203 s result found, , address field value "203 surat"
its because wildcard * in boolean mode returns matches start word appended to. in case no word starts 203 suppose. hence have specify word/letter acts starting part of match. in case 's'
Comments
Post a Comment