SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Zealot
    Join Date
    Apr 2004
    Location
    RS, Brazil
    Posts
    128
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    multi-table search

    Hi guys,

    ive a search engine (very simple...) using mysql. But im using 1 table ... how to search in all tables of db?

    (sorry about my bad english)

  2. #2
    Non-Member
    Join Date
    Nov 2002
    Location
    Earth
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    With PostgreSQL you could probably use UNION, INTERSECT, etc.

    Mysql? You're probably SOL.

    Any any rate, sounds like a poorly designed db schema.

  3. #3
    SitePoint Enthusiast dodga's Avatar
    Join Date
    Apr 2004
    Location
    Germany
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Just a sidenote: One can do JOINs and UNIONs in MySQL, too.
    But without further information about your application (database schema, code, purpose, ...) there's no way to tell what exactly is not working
    remember my name - you'll scream it later

  4. #4
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,479
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    yeah, you need to tell what you are searching for. It'd be better if you post the structure of tables & tell what you want to search or on which columns of which tables you want to search.


    Also, this thread should be in the DATABASES Forums.
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •