 |  |  |  |  |  |  |  |
Complex Database Searching...........
Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
Hi!
How can I seach all of the fields of every table in a databae for a
particular value? When it is found, I want to be able to display the table
name and the field name, then continue to search.
How can I seach all of the fields of every table in a databae for a
particular value? When it is found, I want to be able to display the table
name and the field name, then continue to search.
Not enough info is given here... such as, db used, is this front-end, back-end, etc?
One way to do this is to simply use a SELECT statement.
The best bet is to have the statements automatically generated, having the <tables> and <fields> as variables.
One way to do this is to simply use a SELECT statement.
sql Syntax (Toggle Plain Text)
Last edited by peter_budo; Aug 6th, 2009 at 7:46 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.
•
•
Join Date: Jul 2008
Posts: 481
Reputation: 
Solved Threads: 24
Posting Pro in Training
try this.
I like sword. Attack or Defense.
If the database is oracle you need to play with USER_TAB_COLS view. You need to frame queries dynamically at run time in a loop and execute.
Share your Knowledge.
|
Similar Threads
- Connection to sql database in c# (ASP.NET)
- challenging (C++)
- mySQL database searching for registration (MySQL)
- MySQL vs. PostgreSQL (MySQL)
Other Threads in the Database Design Forum
- Previous Thread: Question about how to design a parts location database
- Next Thread: advice on a database design please
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest Database Design Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
