joeysarsenal Posted September 21, 2007 Share Posted September 21, 2007 Hi, i know there a ways to search a table within the database but is there a way were i can search every single item within the whole database. Link to comment https://forums.phpfreaks.com/topic/70114-solved-searching-the-database/ Share on other sites More sharing options...
Illusion Posted September 21, 2007 Share Posted September 21, 2007 not with the help of MySQL, you can dump whole database and then use some tool to search the text.By the by I have never worked on this. Link to comment https://forums.phpfreaks.com/topic/70114-solved-searching-the-database/#findComment-352179 Share on other sites More sharing options...
joeysarsenal Posted September 21, 2007 Author Share Posted September 21, 2007 i was told it was possible so i thought id ask here. Thanks for the quick reply. Link to comment https://forums.phpfreaks.com/topic/70114-solved-searching-the-database/#findComment-352180 Share on other sites More sharing options...
joeysarsenal Posted September 22, 2007 Author Share Posted September 22, 2007 could anyone help me? Link to comment https://forums.phpfreaks.com/topic/70114-solved-searching-the-database/#findComment-352731 Share on other sites More sharing options...
teng84 Posted September 22, 2007 Share Posted September 22, 2007 if you will be more specific your gonna get better answer than yes Link to comment https://forums.phpfreaks.com/topic/70114-solved-searching-the-database/#findComment-352793 Share on other sites More sharing options...
joeysarsenal Posted September 23, 2007 Author Share Posted September 23, 2007 well i just want to create a search for the whole database were if i wanna search for a certain "Item" within a database i can type it into the search. Just not sure about how to get it to work Link to comment https://forums.phpfreaks.com/topic/70114-solved-searching-the-database/#findComment-353295 Share on other sites More sharing options...
teng84 Posted September 23, 2007 Share Posted September 23, 2007 you have to use the like, soundex for searching sample hi im teng <-- thi is the key now you can do something like select field from table where field like '%hi im teng%' or do an explode $x= explode (' ',hi im teng); "select field from table where field like '%".$x[0]."%' or field like '%".$x[1]."%' etc........." something like that Link to comment https://forums.phpfreaks.com/topic/70114-solved-searching-the-database/#findComment-353629 Share on other sites More sharing options...
joeysarsenal Posted September 24, 2007 Author Share Posted September 24, 2007 Ahh seems a bit helpfull but remeber im a begginer. Would anyone have a link for a tut or something? Link to comment https://forums.phpfreaks.com/topic/70114-solved-searching-the-database/#findComment-353893 Share on other sites More sharing options...
fenway Posted September 24, 2007 Share Posted September 24, 2007 Ahh seems a bit helpfull but remeber im a begginer. Would anyone have a link for a tut or something? Read up on the LIKE comparison operator. Link to comment https://forums.phpfreaks.com/topic/70114-solved-searching-the-database/#findComment-354252 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.