Jump to content

Archived

This topic is now archived and is closed to further replies.

shenniko

Search DB.

Recommended Posts

Hi Guys need a little help,

Pretty new to MySQL and PHP, as i started learing ASP thought Access DB's...

Ive created a sort of search function for my members section, so you can search by Username..

How do you create a "LIKE" statement?

E.g say i enter Da into the search box, it will bring Everything back with "Da" in the database?

All i need is the

WHERE tblCharacter.Character LIKE '$Character'";

Or whatever the code is.

thanks in advance

shenn

Share this post


Link to post
Share on other sites
[!--quoteo(post=344455:date=Feb 10 2006, 05:31 AM:name=shenniko)--][div class=\'quotetop\']QUOTE(shenniko @ Feb 10 2006, 05:31 AM) [snapback]344455[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Hi Guys need a little help,

Pretty new to MySQL and PHP, as i started learing ASP thought Access DB's...

Ive created a sort of search function for my members section, so you can search by Username..

How do you create a "LIKE" statement?

E.g say i enter Da into the search box, it will bring Everything back with "Da" in the database?

All i need is the

WHERE tblCharacter.Character LIKE '$Character'";

Or whatever the code is.

thanks in advance

shenn
[/quote]

WHERE tblCharacter.Character LIKE '%$Character%'";

if $Character == "da" and this is being submitted from somescript.php...

--Mike

Share this post


Link to post
Share on other sites
If you are doing this often, you many want to consider using a FULLTEXT index.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.