adding a space in mysql
| From: | ron wallace | Date: | Wed, 31 Jul 2002 20:32:19 +0000 |
| Subject: | adding a space in mysql | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20926@lists.php.net to get a copy of this message | ||
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
http://health.yahoo.com