Current location: Hot Scripts Forums » Programming Languages » PHP » mySQL search and how relative the search is


mySQL search and how relative the search is

Reply
  #1 (permalink)  
Old 02-25-07, 05:46 PM
phpdoctor's Avatar
phpdoctor phpdoctor is offline
Code Guru
 
Join Date: Feb 2007
Location: New Zealand
Posts: 767
Thanks: 4
Thanked 2 Times in 2 Posts
Question mySQL search and how relative the search is

Hi

Im trying to create a database search and create a list of the found items,
also showing how close the search is to the text in the database.

e.g.
if im searching the word "test" and have these records in the database, the column is Name varchar(100):

testing
abcde
test
test1

The result should be some thing like this:

test 100%
test1 95%
testing 60%

Tell me if you have problem understanding this....
Not really shore how to explain what i need...
Reply With Quote
  #2 (permalink)  
Old 02-25-07, 05:55 PM
Nico's Avatar
Nico Nico is offline
Community Leader
 
Join Date: Sep 2005
Location: Spain
Posts: 8,075
Thanks: 11
Thanked 88 Times in 83 Posts
Reply With Quote
  #3 (permalink)  
Old 02-25-07, 06:06 PM
phpdoctor's Avatar
phpdoctor phpdoctor is offline
Code Guru
 
Join Date: Feb 2007
Location: New Zealand
Posts: 767
Thanks: 4
Thanked 2 Times in 2 Posts
hay, thats a kool command... thanks
I can definitly make something out of this...
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i search from a form to mysql database using php QTortZ PHP 6 06-02-04 09:57 PM
How to create a php mysql site searchable from search engines? Klesti PHP 2 05-16-04 04:09 PM


All times are GMT -5. The time now is 05:57 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.