MySQL Forums
Forum List  »  Newbie

How to select from a tablename where a field value exists
Posted by: Leonard Sokol
Date: July 23, 2005 07:28PM

I would greatly love having any help solving my issue! :)

Let's say I have a table entitled: "example", and have 2 columns. One column is userid, the other is problem.

Let's say a user signs in (via JSP), and WANTS to only view their "stuff" they submitted to the datbase via HTML table. Therefore, let's give an example userid of test.

How could userid, test pull up only their records they've submitted to the database -- not John's, Ralpha's, Tina's, or Cheryl's... just their own records...

Something like: select * from example where only userid = test; I just cannot get the syntax on track! :(

I know this can be done! Any help would BE EXCELLENT!

:)

Options: ReplyQuote


Subject
Written By
Posted
How to select from a tablename where a field value exists
July 23, 2005 07:28PM


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.