Mysql search query

[asrasrasr]

hello friends,

I m tring to search SMP-155-E-ST from mysql data base using following search query

SELECT DISTINCT(prd_id), prd_title, prd_code, prd_pagetitle, prd_desc, prd_img1, prd_price, prd_saleprice, prd_rating, prd_color, prd_material, prd_finish, prd_style, prd_assembly, prd_height, prd_width, prd_depth, prd_weight FROM tbl_products WHERE prd_visible=1 AND MATCH(prd_code) AGAINST('SMP-155-E-ST' IN BOOLEAN MODE) ORDER BY prd_price ASC

but this rutund nothing. but in my database there SMP-155-E-ST exist in pro_code

where i m wrong.

[Shrapnel_N5]

Fulltext index intended to search textual data, not such math expressions
did you try
prd_code='SMP-155-E-ST'
?

[asrasrasr]

Fulltext index intended to search textual data, not such math expressions
did you try
prd_code='SMP-155-E-ST'
?

no i cant use this prd_code='SMP-155-E-ST'. beacuse i m searching SKU CODE , Product Name, Brand Name in single query so this difficult to distingiush search keyword that what is that code prdicut name or brand name so i m using Fulltext index intended. r there is any other way to search

[Shrapnel_N5]

you shouldn't use fulltext search on keywords, such as prducut name or brand name
use standard comparsion instead.

[Shrapnel_N5]

WHERE brand='SMP-155-E-ST' or product='SMP-155-E-ST' OR code='SMP-155-E-ST'

is that you are looking for?

[r937]

please don't write this --

SELECT DISTINCT(prd_id), prd_title, prd_code, prd_pagetitle, ...

DISTINCT is not a function

write this instead if necessary --

SELECT DISTINCT prd_id, prd_title, prd_code, prd_pagetitle, ...

i say "if necessary" because in this query, DISTINCT is not necessary