Finding certain tables in MySQL

[wutang001]

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#.

[VictorN]

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

   SELECT ID FROM MyTable WHERE Character = 'some string'

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

[wutang001]

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

   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!!