Hi Pratik, Indexing is the best way to search SQL DB ...
http://www.sphx.org/index.html --- one of the efficient indexing technique.. once you return the result to flash you can suggest the user with the data.. http://www.designscripting.com/2008/10/14/search-manager%E2%80%93suggest-toolas3/ -sara www.designscripting.com On Jun 25, 3:11 pm, "Pratik. Velani" <[email protected]> wrote: > Hi, > I am creating an flex app where the user enters a title in a txt > input and then enters comments in text area comp, when the user > submits the data is saved into the db.. there is also a search box for > searching the text against the user comment .. for eg:- if the user > types a word in the search field all the rows containing that word in > comment should be listed. i am damn confused in how to perform the > search operation. Tried googling it but couldnt find anything > usefull .. i am using php and mysql .. i think the app would become > very slow if i fetch all the record and then compare it.. is there an > php function or a mysql command for searching in mysql ? :) > > Thanks and Regards, > Pratik. :) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Flex India Community" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/flex_india?hl=en -~----------~----~----~----~------~----~------~--~---
