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
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 space in mysql
How can I add a space to the end of a varchar string
in mysql? I can't seem to do
PROTECTED]
Subject: RE: [PHP-DB] adding a space in mysql
I haven't set up any text-based searches before, but when you say:
snip
If the user types 'Wash' I don't want any matches for
'Washington', 'Washing', etc.
snip
Aren't you, in essence, saying that you want to search for Wash? Meaning
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,