How to get project name by pkey-integer? (sql command)

Question

If I have a pkey-intger (for e.g. bug-20)  how do I find associated project name? Can someone please help?

I believe "project" table does have an entry for pkey and with associated pname, I need to get rid of integer value

Alok Band · Answer

Hi Azwandi,

Thanks for your response, I will give it a try.

Azwandi Mohd Aris · Answer

I assume pkey is the project key? If that is the case, you can query from the project table.

select * from project where pkey = '<PKEY_HERE>';

Use the database susbtring function to extract the pkey from pkey-integer e.g. for MySQL - http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_substring-index