Skip to main content
Question Protected by Paul White
Tweeted twitter.com/StackDBAs/status/676194794411073536
edited title
Link
Kevin Parker
  • 441
  • 1
  • 4
  • 5

How to search whole MySQL database for a particular string

Source Link
Kevin Parker
  • 441
  • 1
  • 4
  • 5

How to search whole database for a particular string

is it possible to search a whole database tables ( row and column) to find out a particular string.

I am having a Database named A with about 35 tables,i need to search for the string named "hello" and i dont know on which table this string is saved.Is it possible?

Using MySQL

i am a linux admin and i am not familiar with databases,it would be really helpful if u can explain the query also.