Where condition do not work in MySQL -

i have query in mysql.

 select * tblname colname = "name"; 

however, no records selected. checked table , there fields matched condition. way, records inserted stored procedure. when tried edit records (colname column), edited records selected. colname has datatype varchar

try see if results , check if have issues white spaces or something...

select *,length(colname) tblname colname "%name%"; 

there possibility ( have issue self on application use) characters match language 'translated' in data e.g greek :
george seems same gΕΟrgΕ there not when convert them lower case

gεοrgε  <> george