mysql - Why is SQL not matching anything? -

i'm running query on mysql database

select * t_college name="cept university" 

even though entry cept university exists in column name, no match found.

this same every other multi-word varchar entry in database. if value matched single word xyz, finds match not multi word ones.

you have whitespace characters (tabs, newlines, etc) other space characters in data.

the best approach clean up. debug problem, use hex():

select hex(name) t_college 

this show each character 2 hexadecimal characters in range 00 ff.

you should able figure out unwanted characters are, , when dr delete them replacing them blank.