search with full name..

[techker]

Hey guys i have a form that shows the full name of a student.

 

like student : Micheal Jackson

 

i need to search the database for that student.

 

but my tables have first name and last name

so the issue i have is i got the full name when in my database i have 2 columns first and last name...

 

so in phpmyadmin i tried the search tab.

 

so i pasted the full name in

 

first and tried LIKE-LIKE%% =....

 

but nothing worked??

[Barand]

... WHERE INSTR('Michael Jackson', firstname) AND INSTR('Michael Jackson', lastname)

[techker]

wow!impressive.what is the instr called so i can look it up?

[Barand]

http://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_instr

[PFMaBiSmAd]

Hopefully, Michael's brother, Jackson Jackson isn't a student too, because that will match him. Also, their distant cousin Jackson Michael and his brother Michael Michael, and other first/last names that can be used as either - Martin Davis, Thomas Martin, Scott Thomas, ... I would concatenate the fields -

 

CONCAT_WS(' ',firstname,lastname) = 'Michael Jackson'

 

[Barand]

And there could also be multiple Michael Jacksons too, but that's always a problem matching name strings and not numeric ids

[techker]

i like!

the first one you gave me works good.it's exactly what i needed.i want to read up on this abit.thx

[Barand]

PFMs is the better solution for the reasons he gave.