Create a little search engine

Search through 1 table

[Twisted Mind]

I would like a search function searching through info and name collumn in my table. for example if i have this search bla it would find it in the info collumn when it would say blah blah bla blah blah

[dreamcatcher]

mysql_query("SELECT * FROM Table WHERE row LIKE '%bla%'");

[kamakaze]

Another handy function that may prove to be useful as your SE grows in the full-text search functions:

[dev.mysql.com...]

[Twisted Mind]

Thanks guys i dind know how to write that query (This was actually a mysql question right?

[Twisted Mind]

How do i change my table to fulltext i changed it to mysam but i cant get the rows to fulltext...

[Twisted Mind]

anyway its not a real big search enginge its just for searching for products in a kinda library way :D

[Twisted Mind]

Anyway is there a script wich will give microsoft as result when the search word (Whatever you want to call it) would be microsoftt (with extra letter) if some1 misspelled :D.

[Twisted Mind]

no one know a sollution on my last post it isnt urgent anyways

[coopster]

There are functions that find near misses. Perhaps this thread will help:
[webmasterworld.com...]

[kamakaze]

How do i change my table to fulltext i changed it to mysam but i cant get the rows to fulltext...

You don't change the actual table but rather the field that you will be searching. What database are you using?

[Twisted Mind]

i know its only a field i have mysam tables and if you want another one i can switch really fast,

but thats not what i was asking for :D

[arran]

Has anyone tried to get mysql's full text indexing working with 'near misses'? I read it could be done with mysql's soundex but after doing some tests, I decided the results wouldn't be very effective.

It's now time to revisit this as a worrying number of visitors are leaving my site after (poorly) searching for products that do exist.

arran.