# vice versa

**URL:** <https://forums.percona.com/t/vice-versa/547>\
**Category:** Other MySQL® Questions\
**Created:** [November 30, 2007, 6:37am UTC](https://forums.percona.com/t/vice-versa/547 "2007-11-30T06:37:05Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![asmith](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@asmith](https://forums.percona.com/u/asmith)\
**Post date:** [November 30, 2007, 6:37am UTC](https://forums.percona.com/t/vice-versa/547/1 "2007-11-30T06:37:05Z")

</div>

select field\_name from table\_name where id=“3”;

this above code show the value for filed\_name ,

how can i have backward ?  
i mean if i have a value, i want to search this value belongs to what column ?  
example  
:  
what is the column name where id=3 and its value is “aaa” .