I'm a beginner on MySQL. I tried to run this statement

SELECT* FROM address WHERE email=a@abc.com

but it shown an error message. What's wrong?

First: if you get an error it's always helpfull if you give the error
in this case the error can be the fact that you forgot a space between FROM and *

try this

SELECT * FROM address WHERE email = 'a@abc.com'
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.