How to find a record based on removeme indentifier?

**stasila** · 2007-02-02, 01:17 PM

Hi Forum,

Quick question how can I find a record based on that information? removeme.php?identifier=14ab2940-6a85-ab0d-c240-45c217d24357

**leenwebb** · 2007-02-02, 04:03 PM

If possible, the easiest thing would be to do a direct database query in a MySQL interface. Then you can look at the rest of the record to find out first/last name, etc.

Good Luck!

**stasila** · 2007-02-02, 04:17 PM

Hi There,

Can you give me a quick example? I'm not very familiar with sql query
Thank in advance.

**Angel** · 2007-02-02, 04:51 PM

I am not sure I understand what you are wanting to do, but if I did, I believe what you are trying to do is find the contact that corresponds to identifier value.

If you have a MySQL admin tool, e.g. phpMyAdmin, you should be able to locate the record using the following query:

SELECT * FROM contacts WHERE id = '14ab2940-6a85-ab0d-c240-45c217d24357'

**stasila** · 2007-02-02, 08:55 PM

Hi Angel,

Thanks for reply, Running that query doesn't return any information.

All information i have about a client is this opted out link with identifier id http://somehost/removeme.php?identif...0-45c217d24357
If i run a query from leads/contacts/prospects it's returning no result. So I'm guessing opted out identifier is different compare to id record in leads. For example if you send a campaign to your self and look on opted out identifier it will be different from your id in leads/contacs.

Thanks