ansaurus

Question

how to find a sql field name that has a record like '%text%'

Answer 1

+1 A:

This may help you:

http://blog.sqlauthority.com/2008/08/05/sql-server-2005-get-field-name-and-type-of-database-table/

Nissan Fan 2010-06-21 19:09:01

Google is our friend :-)

Luc M 2010-06-21 19:13:31

Answer 2

A:

I don't have specific answer. But i use PHP code for MySQL that calls "show tables" and then for each table calls "show create table [table_name]" I export the result to a text file and then search it...

aviv 2010-06-21 19:09:39

Answer 3

+2 A:

like this

select column_name,table_name
 from information_schema.columns
where column_name like '%text%'

Misunderstood your question, see here: Search all columns in all the tables in a database for a specific value

SQLMenace 2010-06-21 19:12:09

i dont care what the clounm name is i want the names of the columns that have a certain string od data with in records or data points of the coloumn. more like this:select Col_Name where Col_Name.data = 'sometext'i dont want fields called sometext... i want the records of the tables that have sometext to report to me the names of the fields that have this data.

kacalapy 2010-06-21 19:17:49

In that case see here: http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1#2

SQLMenace 2010-06-21 19:20:05

ansaurus

tags:

views:

answers:

how to find a sql field name that has a record like '%text%'

related questions