[RESOLVED] Where clause not working in MySQL

[conjurer]

I am trying to do a search on a table and allow input from the user to construct a where clause. When I tried to search for a list of organizations with "P" in the name using the following:

WHERE organization like '%P%' Order By city

I get a list of all rows sorted by city. It is not using the

like '%P%'

to filter the rows returned.

Any ideas what I am doing wrong here?

[conjurer]

My mistake, it is working, just too many rows met the criteria