1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Rep Power
    how can i search within the results of a sql query?

  2. #2
  3. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    In MySQL, you'll have to do this through application logic. Grab your results in a Perl script (or whatever else takes your fancy), and then search through them. If you have access to a database which supports sub-selects then you can do it all in the DB, but as this is posted to a MySQL group I imagine you probably have MySQL. Hopefully at some point in the near future MySQL will add support for sub-select's (it's on the ToDo list).

Similar Threads

  1. Cgi Search feature script
    By butsy_7 in forum Perl Programming
    Replies: 5
    Last Post: January 22nd, 2004, 07:43 PM
  2. How can I perform a search with a previous search results?
    By charlie_tango in forum MySQL Help
    Replies: 1
    Last Post: January 17th, 2004, 10:06 AM
  3. Using sessions for search / results pages
    By Quirk in forum PHP Development
    Replies: 10
    Last Post: December 15th, 2003, 08:36 PM
  4. Google search results
    By webwonderuk in forum Search Engine Optimization
    Replies: 5
    Last Post: November 28th, 2003, 02:25 AM
  5. search results coming from multiple tables
    By frostfire in forum MySQL Help
    Replies: 0
    Last Post: August 12th, 2003, 09:23 AM

IMN logo majestic logo threadwatch logo seochat tools logo