incomplete search results

[Anon]

Using MySQL, I have 2 tables with names and addresses. I have a search script that when used in one table, will pull up all the states. If I use the same script to search the second table, it only pulls up one state. Yet, in using phpMyAdmin, it shows all the states listed under the correct field. Any ideas what is going on. Could this be a server problem?

[Anon]

I figured out what part of the problem is. Some search fields work fine, but in several others, I have to press the space bar one time, before entering in the information I am searching for.
I am wondering if there is an easy way to fix this without having to go back and edit all the entries in one table.

[Anon]

If I understand what you are saying, some of the data has a leading blank that you want to get rid of? Use the built in SQL function LTRIM:

update theTable set theColumn = LTRIM(theColumn)