about comparison operators, LIKE operator
 

Can anybody ttell me the query for the question below, plz?

(a) Output the names of students and their addresses for those students who are living in Hunghom.

thx a lot~~~

Re: about comparison operators, LIKE operator
 

The details depend on how you've set up your table, but something like this:

select name, address from MyTable where city = 'Hunghorn'

Or if you need to pick Hunghorn from the address itself:

select name, address from MyTable where address like '%Hunghorn%'