[SOLVED] Need query

[Sparrow]

Okay On my website I have a members table that automatically updates itself.  Now I want to split this table into different sections based upon what members have entered in their "hub" field on the msql database table.   

 

For example:

I need a mysql query that will bring up only users who have "Los Angles International" in thier "hub" column

 

So I guess the query would start off like this:  SELECT * FROM users... then what?

[akitchin]

this involves the use of a simple WHERE clause:

 

SELECT stuff FROM table WHERE column='the column value'

 

have a look in the MySQL manual for more about the WHERE clause.

[Sparrow]

Thank you. So I assume it would be in my case:

 

SELECT * FROM users WHERE hub=Los Angles International.

 

I'll have to test it

[akitchin]

no - you need to add single quotes around 'Los Angeles International' since it is a string.  before delving into writing this stuff, perhaps an intro tutorial on writing queries would be helpful.  it will save you a fair bit of time in the end.

[Sparrow]

Okay Thank you.  I tested it in PHPMyadmin and it worked.  If I need additional help in the future I'll come back here.