How can I add a space to the end of a varchar string
in mysql?  I can't seem to do it directly, and I tried
str_pad and other things, but no luck so far.  The db
doesnt hold the value of the space...its getting
trimmed somewhere(?)

The reason I want to do this is so I can search for
exact matches on one word strings without stemming:
...WHERE name LIKE '$var %'.

If the user types 'Wash' I don't want any matches for
'Washington', 'Washing', etc.

Thank You All

Do You Yahoo!?
Yahoo! Health - Feel better, live better

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to