[SOLVED] Help modifying SQL to include another field

[webref.eu]

Hi All

 

I need help from experts to modify this SQL query: 

 

$query = "select * from Users where Username like \"%$trimmed%\" order by Username";

 

To also search the Email field of my data, i.e. not just the Username field.  This is what I've tried so far, and it doesn't work: 

 

$query = "select * from Users, Email where (Username like \"%$trimmed%\" OR Email like \"%$trimmed%\")  order by Username";

 

Can you help?

 

Many thanks

[webref.eu]

OK guys, I worked it out, I had an error towards the beginning of the statement where I had mentioned Email in error, should be: 

 

$query = "select * from Users where (Username like \"%$trimmed%\" OR Email like \"%$trimmed%\")  order by Username";

 

Thanks