Guest Posted August 12, 2008 Share Posted August 12, 2008 I am performing a fulltext search for businesses in a database but I want them to be able to select a category but the results wouldn't necessarily be in that category. I was thinking group by or somthing like that but just cant seem to wrap my brain around it could someone help please. Quote Link to comment Share on other sites More sharing options...
fenway Posted August 12, 2008 Share Posted August 12, 2008 Huh? Quote Link to comment Share on other sites More sharing options...
Guest Posted August 12, 2008 Share Posted August 12, 2008 lol sorry it sounds more confusing than what it is. Lets say I have a business name field and a category field for the businesses I want to make a sql query that fulltext searches the business name fiels (I got that part) and I want to get a specific category first Example the best I can search for business name mybusiness and category mycategory I run the full text it then brings up mybusiness example1 in category automotive mybusiness example2 in category mycategory mybusiness example2 in category restaurant and I want the one with mycategory to come up first but I still want all the other rows. Does that make any sense? Quote Link to comment Share on other sites More sharing options...
fenway Posted August 13, 2008 Share Posted August 13, 2008 Are you talking about ordering the results after the match? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.