Searching MySQL Database

[roavanet]

I am trying to search my database to find data. For example

Search "wand" will find all such as "magic wand". As it is now, it has to be a 100% match.

SELECT * FROM inv WHERE class='wand' or item='wand' or dis='wand' ORDER BY inv desc;

Any assistance would be appreaciated.

[matt_4013]

Use wildcards (%) in your query, eg.

$search_string = "wand";

$sql = "SELECT * FROM inv WHERE class='%".$search_string."%'";

By putting the % in front and back it will match anything with the word wand in it 🙂

[roavanet]

Thanks a mil... That helps alot... I feel like I should have known that...

John

[roavanet]

Originally posted by matt_4013
Use wildcards (%) in your query, eg.

$search_string = "wand";

$sql = "SELECT * FROM inv WHERE class='%".$search_string."%'";

By putting the % in front and back it will match anything with the word wand in it 🙂 [/B]

I think that I am getting it. I am using the following:

$sql = "SELECT * FROM inv WHERE class='%".$srch."%' or item='%".$srch."%' or dis='%".$srch."%' ORDER BY inv desc";

If I " echo $srch; ", then it displays what it is searching for but when I get this, I am not getting the data that I am searching for, even though I can see it in the raw data.

Thanks in advance for any assistance on this.

John

[matt_4013]

Try using like 🙂

SELECT * FROM inv WHERE class LIKE '%wand%'

🙂

[roavanet]

Originally posted by matt_4013
Try using like 🙂

SELECT * FROM inv WHERE class LIKE '%wand%'

🙂

Thanks, worked great.