MySQL return an empty results

Question

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

can anyone helps me !!!!

no i've make sure there is nothing and iv'e try a million time with different names and same results everytime — Ghassen Arfaoui
– Ghassen Arfaoui, Commented Apr 27, 2017 at 19:04
yes i can get results when iv execute SELECT * FROM adherent — Ghassen Arfaoui
– Ghassen Arfaoui, Commented Apr 27, 2017 at 19:05
Try TRIM(). SELECT * FROM adherent WHERE TRIM(nom)="arfaoui" — Rohan
– Rohan, Commented Apr 27, 2017 at 19:08

Darshan Mehta · Accepted Answer · 2017-04-27 19:06:12Z

3

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.

answered Apr 27, 2017 at 19:06

Darshan Mehta

31k14 gold badges75 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

it work's thanks i find out that whenever i try to add data using java ive add a blank space in the end thanks you've saved me

you have to accept the answer if that help you @GhassenArfaoui not just say thank you :)

Sorry @ YCF_L i did not get what you want to say !! .

@GhassenArfaoui read this to undersatanf more meta.stackexchange.com/questions/5234/…

Jenish · Accepted Answer · 2017-04-27 19:05:16Z

1

try this :

SELECT * FROM adherent WHERE nom=" arfaoui"

answered Apr 27, 2017 at 19:05

Jenish

5334 silver badges16 bronze badges

it work's thanks i find out that i have add a blank space in the end a simple mistake can damage a whole program thanks <3