How to query a first name and last name string in MySql

Question

I'm new to database and querying in MySql. I have a table in my database with id, fistname, middlename and lastname. In my webapp, I have a search box so that I can search my database using the firstname, middlename and lastname and it will display the result in my web app. Do I need to use SELECT statement to do this and what condition should I query?

Please advise.

Many thanks.

bumperbox · Accepted Answer · 2011-06-06 01:50:07Z

2

select id, firstname, middlename, lastname where firstname like '%searchterm%' or middlename like '%searchterm%' or lastname like '%searchterm%'

this will give you a very broad result, as it matches on the search term anywhere within any of the name fields.

you can also use 'searchterm%' to match ones starting with the searchteam, and 'searchterm' for an exact match

answered Jun 6, 2011 at 1:50

bumperbox

10.2k6 gold badges46 silver badges66 bronze badges

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

3 Comments

bumperbox Over a year ago

if you want only 1 row returned, them put limit 1 on the end of the query

domlao Over a year ago

Thanks. Do I need a special encoding of a space character. Because it gives me no result if I include spaces in my query search like John Bonson?

bumperbox Over a year ago

you would need to split that into parts "john" and "bronson" and match on both of those parts

Collectives™ on Stack Overflow

How to query a first name and last name string in MySql

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related