View Full Version : search all fields for string
09-25-2006, 11:12 PM
I have an email address entered wrong in some mystery field in the db, but have no idea where it is to correct. The only way I know about it is it comes back with bounced emails. Not sure if it is stuck in my CRM's cache, or in the db. Is there a way I can search all tables, all fields for the specific string???
09-26-2006, 01:56 AM
I'd say you would have to search each table separately. If you don't then you would have to use a UNION and you would have to search the same number of fields in every table.
The good news is you CAN search all fields of a table if you know the fields.
Normally an IN list can be used to search multiple words from a single field like this:
where qux in ('table','chair','sofa','television')
the good news is you can also do the inverse and search for a single term in multiple fields:
where 'yoursearchterm' in (field1,field2,field3,field4)
the drawback of course is that it must be an exact match. If the email address you are searching for isn't the only item in the field (i.e. if it is part of some larger text), then you can only use LIKE and must name every field you are searching for.
09-26-2006, 02:10 AM
I had a feeling it was going to mean searching each table, but thought it wouldn't hurt to ask. I do appreciate the speedy response:D
Powered by vBulletin® Version 4.2.2 Copyright © 2017 vBulletin Solutions, Inc. All rights reserved.