query

Question

SELECT * FROM document WHERE MATCH (Title) AGAINST ('web' )
this query is use output come this order show in below image

iam don't want this order.

search web output came this order show in below

how?

tell me query...
reply me soooooooooooooon

ashleyturnier · Answer

I think this query is right : SELECT * FROM document WHERE Title LIKE %web%. This query is suitable to your question.

Jignesh Trivedi · Answer

hi Agree with Suthishsome thing wrong in given picture... can please explain in detail what you want?

Suthish Nair · Answer

That is not possible because your document ID 6 having value as graphic web design not web site dealer. Rearrange the values in master table according to your logic..

Kiran Kumar Talikoti · Answer

Hi Rasul Try this select * from document where title like '%web%' order by Title desc

rasul moh · Answer

this is not correct answer

venkata kumar · Answer

hi try the fallowing SELECT * FROM document WHERE Title like '%web%'