how particular string from whole database.?
posted 9 years ago
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...?
e.g i want to find string "xyz" in whole database
can anyone suggest me...?
posted 9 years ago
select count(*)
from table
where mystring = 'xyz'
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'
posted 9 years ago
Or if you want a substring:
where mystring like '%xyz%'
where mystring like '%xyz%'
[OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
| Consider Paul's rocket mass heater. |