thanks, helpers, but I think I have a simple solution:
I will insert a space at the front of the string,
where the db must accept and retain it.
BTW, here is the SQL I am working with:
//
elseif ($desc==desc) {
$sql="SELECT bandid, bandname, bandesc, bin
allace'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] adding a space in mysql
I haven't set up any text-based searches before, but when you say:
If the user types 'Wash' I don't want any matches for
'Washington', 'Washing', etc.
Aren't you, in essen
uot;wash" appears.
If that's the case I'm sure somebody will correct me and I'll learn
something in the process.
-Original Message-
From: ron wallace [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 4:32 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] adding a sp
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