PHP advanced search issue

PHP advanced search issue

by nandana » Tue Jun 05, 2012 6:55 am

I have some people list in database.

Sebin simon
Sijo simon
Aby simon
Simon dcruz
Angel simon


I need a query which on searching for "Angel simon" gives me the result like this

Angel simon
Sebin simon
Sijo simon
Aby simon
Simon dcruz


Is there a way for that?

Re: PHP advanced search issue

by XainPro » Tue Jun 05, 2012 12:12 pm

you can get the result like this

Angel simon
Sebin simon
Sijo simon
Aby simon
Simon dcruz

by searching the word Simon

it really depend on your query

Code: Select all

select * from persons where name like '%simon';