MySQL Forums
Forum List  »  Full-Text Search

Common Query for a DB
Posted by: Divya A
Date: September 17, 2010 01:00AM

Hi ,

My scenario is ,

* I have to find a search keyword from the database which has n number of tables with different fields in it.
* I wont know what field will be in the table.

Can u pls help me in writing a "query to get a varchar field from all the tables in the DB" ...??

more or less like a common query for search .. to get all the varchars which matches the keyword of search.

Thanks in advance..

Regards,
Divya



Edited 1 time(s). Last edit at 09/17/2010 01:19AM by Divya A.

Options: ReplyQuote


Subject
Views
Written By
Posted
Common Query for a DB
3788
September 17, 2010 01:00AM
1824
September 18, 2010 04:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.