sql - Simple MySql select statement returns 0 rows -

this rather silly, don't know what's problem here. have table 'profiles' column 'country', filled table tab separated value file , table view seems fine.

now when executing query:

select * profiles country = 'sweden' 

nothing gets returned, although table has more hundred entry country 'sweden' , double checked spelling.

but when executing query:

select * profiles country regexp 'sweden' 

it returns results expected.

what's cause of ? , how fix ?

here data file used fill table:

0   f   germany 1   f   canada 2       germany 3   m   mexico 4   m   united states 5   m   united kingdom 6   m   finland 

thanks reading

please try operator.

select * profiles country '%sweden%'