I'm having issue with my study project for creating database in MySQL.
I've imported data using LOAD to my created table from a CSV file. Now when I'm executing
select * from mytable
select * from bi_jogging.routes as r where r.Creator_Email="email@example.com"
You can try using the query:
select * from bi_jogging.routes as r where r.Creator_Email like "%firstname.lastname@example.org%"
If like operator shows the result then there may be white spaces in the email, please double check..
For join try this:
select * from bi_jogging.routes as r join bi_jogging.buddies as b on b.Email like '%r.Creator_Email%'