mysql - How to get value by only giving part of a name in a query -

i need id query right table looks this

id = 2000 name = 'johnson, bob' ssn='1234' 

my login page asks last name , ssn , use info in query id.

im trying figure out how write query when name field contains both lastname, firstname. using mysql.

write query this: customize name parameter before send query

string namevalue={name ui}+",%"; 

sql query:

select id  {your table name} ssn={ssn value ui} , name namevalue; 

let me know if works