KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm trying to search a whole table in mySQL for a string. I want to search all fields and all entrees of a table, returning each full entry that contains the specified text. I can't figure out how to search multiple fields easily; here are the details: The table is "clients". It has about 30 fields and 800 entries, too much to show all at once in a browser. I would like to search for a name (i.e. "Mary"), but it could be in the shipping_name field or the billing_name field , or the email field, etc. I would like to search all fields for any entries that contain the string "Mary". This is what I think should work but doesn't: SELECT * FROM `clients` IN 'Mary'
Tags (comma-separated)
Save Edits
Cancel