Forum Moderators: coopster

Message Too Old, No Replies

PHP/MySQL Search Engine

Full Text or Spec searching?

         

ahmedtheking

7:52 am on May 16, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Just to clarify, if I wanted to do a search engine query, for a full text, all the columns in my db, would my query look like this:

SELECT * FROM db WHERE field LIKE var1 OR field2 LIKE var2 ... and so on?

If so, how could I get the results to be displayed in order of relevence?

anshul

9:32 am on May 16, 2005 (gmt 0)

10+ Year Member



Or search keyword ( keywords, if it's a phrase ) in Web page content ( HTML ) of all Web pages, that is in db?

ahmedtheking

11:01 pm on May 17, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Yeah but this is a DB of people's portfolios, is it poss to search in such a way like I said and then maybe run a script to see how many matches there were?