Retrieve two database column fields in one textbox VB.NET MySQL

Question

i have this search function to search for Firstname Middlename individually with their own CheckBox, this thing came to my mind if i want to search for Firstname and Middlename together in one Textbox with space of course and tried to use SELECT statement with CONCAT, but it didn't work.

it looks like this one:

If CheckBox1.Checked And CheckBox2.Checked Then
            SQL = "SELECT * from student where CONCAT(fname,"" "", mname) like '%" & TextBox1.Text & "%'"
End if

Mohit S · Accepted Answer · 2014-09-08 09:04:50Z

1

Try this:

If CheckBox1.Checked And CheckBox2.Checked Then
  SQL = "SELECT * from student where CONCAT(fname,' ', mname) like '%" & TextBox1.Text & "%'"
End if

EDIT

SELECT * FROM student WHERE MATCH (fname, mname) AGAINST ('+" & TextBox1.Text & "* +" & TextBox1.Text & "*' IN BOOLEAN MODE)

Might be this will give you the desired result

edited Sep 8, 2014 at 9:04

answered Sep 8, 2014 at 4:49

Mohit S

14.1k6 gold badges36 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sky Scraper Over a year ago

still doesn't work, if i press space after the Firstname, it shows nothing.

Mohit S Over a year ago

@SkyScraper- I think then you must have a look on Full-Text Search Functions

Collectives™ on Stack Overflow

Retrieve two database column fields in one textbox VB.NET MySQL

1 Answer 1

EDIT

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

EDIT

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related