MySQL Forums
Forum List  »  Newbie

Query to retrieve column and row from some name
Posted by: Lucas
Date: August 15, 2005 04:31AM

I'm not new to mysql but I've never used it in more than just a very basic manner.

What I want to do which I can't fin d the way to is to retrieve where a given name is found on a table. This table is not the regular sort of table. I don't know what would be the proper name for this type of table but it basically looks like this:

Type name1 name2 name3
name1 bla1 bla2 .....
name2 ....
name3

I want to search the whole table for, say, "bla2" and for the query to return in which row and column the bla2 is found (it will be in more than one place).

So I would expect something like:

Type name1 name2 name3
name1 bla2
name2
name3 bla2


Sorry but I can't find a way of explaining it with words.

I just need to know which two types I need to get a given type. So there I know that
Name1+Name2 = bla2
Name3+Name1 = bla2
etc...

Thank you in advance.

L.

Options: ReplyQuote


Subject
Written By
Posted
Query to retrieve column and row from some name
August 15, 2005 04:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.