On 30 Oct 2007 at 14:05, James Dennett wrote: > > -----Original Message----- > > From: Bernie Cosell [mailto:[EMAIL PROTECTED]
> > I'm trying to correct several little problems in a DB I have and I've > > now tried three [maybe four] freeware DB managers and not one includes > > a search function. > It would be very helpful if you'd define what you mean by "a search > function". What databases *do* is store and search Data; SQLite support > relational searches and full-text search, and other databases also allow > searching in various ways either for exact matches, LIKE clauses, > regexps, fuzzy search, natural language search, etc. I guess you've never used a [good] GUI-driven DB manager/administration pgm. The problem is that it is *hugely* easier to do a few clicks and "search" than to keep typing in 80-character SELECTs until you get the WHERE clause just-right, and then go back and edit the command to be an UPDATE (and don't mistype anything!). > I'm also wondering what you mean by a "DB manager" -- do you mean a > graphical user interface interfacing to an underlying database engine, > or something else? Yes. I'm not sure if you've had a chance to play with phpMyAdmin but it makes administering, taking care of, and tweaking MySQL DBs a real snap. The search function, for example, gives you a layout of the table and you can put in the search-values for the fields you care about and then you get a "minitable" of the search results [which are then easy to edit, delete, whatever]. /Bernie\ -- Bernie Cosell Fantasy Farm Fibers mailto:[EMAIL PROTECTED] Pearisburg, VA --> Too many people, too few sheep <-- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
