[PHP-DB] adding a space in mysql

2002-07-31 Thread ron wallace
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

[PHP-DB] adding a space in mysql

2002-07-31 Thread ron wallace
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