Finding certain tables in MySQL

hello everyone.

I am trying to create a function by finding a "Characters" ID using a string.

So here is the basic concept, the user enters the name of the Character (a string), and the function looks in MySQL for the entered string, and if it finds the name, it will look for the ID in the same row. Then afterwards, the function returns to the ID of the character.

Howabouts would I get started on this? I am nowhere near familiar with using MySQL in C#.

1. Learn SQL
2. Use SELECT clause... Something like
   Code:

   ---

   SELECT ID FROM MyTable WHERE Character = 'some string'

   ---

   where MyTable is a table, Character is "the Character (a string)", ID is an id

Quote:

---

Originally Posted by VictorN

1. Learn SQL
2. Use SELECT clause... Something like
   Code:

   ---

   SELECT ID FROM MyTable WHERE Character = 'some string'

   ---

   where MyTable is a table, Character is "the Character (a string)", ID is an id

---

Thank you!!