CODEWITHSUNDEEP
javamysql
Ghassen Arfaoui
Ghassen Arfaoui

Reputation: 59

MySQL return an empty results

hey everyone i have this data in my database

and where i try to execute this SQL commande 

SELECT * FROM `adherent` WHERE nom="arfaoui"

it returns this empty results enter image description here

can anyone helps me !!!!

Upvotes: 0

Views: 67

Answers (2)

Darshan Mehta
Darshan Mehta

Reputation: 30819

Try this query:

SELECT nom, LENGTH(nom)
FROM `adherent` 
WHERE nom LIKE "%arfaoui%"

It will return that row along with number of characters. That should help finding out whether it contains whitespace or any other characters.

Upvotes: 3

Jenish
Jenish

Reputation: 535

try this :

SELECT * FROM adherent WHERE nom=" arfaoui"

Upvotes: 1

Related Questions