How I can search data in database? search data including text, number and datetime

[SaSystem1989]

hi all, is it possible to Search data in database? with a single sql script or some tools will help me?
for example ,I have a HR database ,and I want to search 'CEO', $2354.00 or '12/4/1996' in all of the records.

[Meetee]

Use where condition. For eg.

select * from HR_Master where position = 'CEO' and salary = 2354 and date = 'YYYY-MM-DD'

[SaSystem1989]

what i mean is

search all columns of all tables ,search 2345 in the database ,returns table's names and column's names
for example:

owner tablename columnname
-------------------------------
HR salary monthly
HR salaryhis yearly
......

[Meetee]

Look up for information_schema which stores metadata information of database.

[Rabbit]

If you're looking for that value anywhere in any table in any row in any field in the database, you will have to return all the information schema data as meetee suggests. And then you will have to loop through it creating dynamic sql to do the actual search.

Just so you are aware, this is take tremendous amounts of time unless your database is small.

[coding master]

use this conditon

Select * from HR_Table_Name where Designation='CEO' AND Salary='2354RS'AND date='MM-DD-YYYY'

[NeoPa]

I'm afraid that wouldn't work for reasons already discussed in the thread (and others which haven't been - like it wouldn't match any records anyway).