Searching 10% in mysql

[ole90]

I'm trying to allow users to search for items in my table that begin with 10%. However when a user searchs for 10%, it justs acts like: Find all words beginning with 10 and anything after, which isn't what I want ^_^. I know the % is used to represent any amount of characters after, so I'm wondering how to make % a literal character :X?

Any help would be greatly apprciated ^_^

[Jake Arkinstall]

Replace occurances of % with \%:

<?php
$input = '10%';
$input = str_replace('%', '\%', $input);
mysql_query("SELECT .... FROM .... WHERE .... LIKE '{$input}%'");

[TimIgoe]

Because % is the wildcard character, just like you'd use " or ' to contain strings, you need to then escape the wildcard to force mysql to see it as a literal character.

As arkinstall says, turn % into \% in your query.

[ole90]

Thanks Works like a treat!