I have a select statement as below.
select * from candidate where resume REGEXP 'JAVA';
i am developing an application for searching resumes. I have a tex box where I can give keywords like Java in about example.
The applciation is in MSQL as a back end. I am taking the value from the text field in a string variable . How to use the variable in select statement above instead of actual values?
The application is in vb.net.