Forum Moderators: open

Message Too Old, No Replies

T Sql Newbie

         

andrewsmd

2:03 pm on May 28, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I have a search page that has a list of categories, and branches to choose from. It also has a textbox where the user can enter search keywords if he/she wants to. Here is my problem, I have full text indexing enabled on all of my columns and I need to search if their keywords are in the entire row. Here is the pseudo on my sql statement

select jobs.title, jobs.salary, jobs.description branches.branch, categories.category from jobs, branches, categories where branches.branchID = 'userSelection' AND categories.categoryID = 'userSelection' AND /*here is where my tsql needs to go to search the entire jobs table and get rows back where they match any of the user's keywords they entered*/