This is a discussion on Referencing the Table Name within the MySQL Database forums, part of the Database Forums category; Say I have a Table called Predator: country(varchar 20), animal(varchar 20) And I want to search for the ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Say I have a Table called Predator: country(varchar 20), animal(varchar 20) And I want to search for the animal "Python" in my Predator table, but if it is present, I want to simply reference the name of the table...so "Predator" would return. I am sure this is really simple, but I have looked and looked with no luck. Thank You Very Much, Dan |
|
|||
|
"Dan J." <spwpreston@gmail.com> wrote in message
news:1141461706.226104.4060@i39g2000cwa.googlegrou ps.com... > And I want to search for the animal "Python" in my Predator table, but > if it is present, I want to simply reference the name of the table...so > "Predator" would > return. SELECT DISTINCT 'Predator' FROM Predator WHERE animal = 'Python' Regards, Bill K. |