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?
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?