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. Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
joeysarsenal Posted September 22, 2007 Author Share Posted September 22, 2007 could anyone help me? Quote Link to comment 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 Quote Link to comment 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 Quote Link to comment 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 Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.