Jump to content

Mysql category prefered but not required


Guest

Recommended Posts

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.

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?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.