Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Full text search

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I want to implement a search engine and i have created a database using MySQL with one table that has three columns.
description char(255)
url char(255)
imp float
What i want to do is a Full Text Search on the description column by the html form input and after that to add the float contained in the imp column to the float returned by the full text search.I then want to sort the recordset by the result returned by the addition.
Could somebody help me with the MySQL sql syntax to use to achieve it?
 

To find your selected text and the imp value from the records, you'd have a query like:

select imp where descrpition like '%[user inputted search term]%';

But from your table structure, it seems to me that you're missing a uid for the records. I don't quite know how to suggest to you that you handle the results you're obtaining without.
 

To find your selected text and the imp value from the records, you'd have a query like:

select imp where description like '%[user inputted search term]%';

But from your table structure, it seems to me that you're missing a uid for the records. I don't quite know how to suggest to you that you handle the results you're obtaining without.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top