issue with "%" MySQL

Question

I have a newbie question.

The "%" seems not working here whereas "Troyes" is in the database:

$requete = $bdd->query("SELECT * FROM club where ville='Tro%'")->fetchall();

But here the fetchall give me what I want:

$requete = $bdd->query("SELECT * FROM club where ville='Troyes'")->fetchall();

do you know what's wrong with the first query ?

Thank you for your help !

I think you're looking for "Like", check this out http://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html#operator_like — Prashank, Nov 28 '15 at 15:51

score 3 · Answer 1 · answered Nov 28 '15 at 15:52

3

You need to replace = with LIKE, e.g.

SELECT * FROM club where ville LIKE 'Tro%'

answered Nov 28 '15 at 15:52

wogsland

1 Answers1