You can make the normal type of sql query:
select * from users WHERE username='USERNAME' AND password='PASSWORD';

You can create this string in c-script using the str_cat function:
Code:
 
string query; // holds the mysql query
string username; // holds the username
string password; // holds the password

//Take input here//

str_cat(query, "select * from users WHERE username='");
str_cat(query, username);
str_cat(query, "' AND password='");
str_cat(query, password);
str_cat(query, "';");



The str_cat function basically adds the second string given to the function at the end of the first string. For more information on this function, look it up in the manual.