how particular string from whole database.?

[suresh sargar]

i want to find particular string from whole database where it is how many times present in database.

e.g i want to find string "xyz" in whole database

can anyone suggest me...?

[Paul Campbell]

suresh sargar wrote:i want to find particular string from whole database where it is how many times present in database.

e.g i want to find string "xyz" in whole database

can anyone suggest me...?

select count(*)
from table
where mystring = 'xyz'

[Jeanne Boyarsky]

Or if you want a substring:
where mystring like '%xyz%'