Login | Register | FAQ
Anonymous

PHP advanced search issue

+ Post a reply

2 posts Page 1 of 1


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?
User avatar

nandana

  • Posts: 1
  • Joined: Tue Jun 05, 2012 6:39 am

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';
User avatar

XainPro

  • Posts: 3567
  • Joined: Fri Feb 17, 2012 8:10 pm


+ Post a reply

Page 1 of 1

?>