|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Php Mysql Search Engine
Hey Everyone,
I need some help in finding good articles on building good search engines for a local database in a site. I took a look at Mitch's article and the searching part is fine, but I can't figure out how to index the keywords into the word table. Any help would be great! Thanks
__________________
Nothing is Everything
|
|
#2
|
||||
|
||||
|
Do you really need a keywords table? I haven't read Mitch's article, but most every site I build has a search engine in it. Unless you are after something specific, have you tried using the usual SQL "like '%foo%'" approach?
|
|
#3
|
|||
|
|||
|
Ya that returns too many results.
|
|
#4
|
||||
|
||||
|
what about using multiple WHERE LIKES? e.g.
Code:
"WHERE body LIKE '%something%' AND body LIKE '%foo%' AND body LIKE '%bar%'" |
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Php Mysql Search Engine |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|