Removing Spaces From DB Queries

jaZon

Is there anyway to remove spaces from queries in MySQL? I only want to remove the spaces from one column of data. Is that possible?

Thanks,
Jason

tha_mink

You mean like this?

$column = [the data from your column];
$column_with_no_spaces = ereg_replace (" ", "", $column);

jaZon

The command I'm using to pull that bit of info out is

$row[product]

Anyway to take the spaces out of that?

tha_mink

$product = ereg_replace (" ", "", $row['product']);

That should do it...

jaZon

Awesome, thanks a bunch. How do you find commands like that, anyway? I searched for some type of replacement statement on php.net, but had no luck.

wizkid

Originally posted by jaZon
[...] How do you find commands like that, anyway?[...]

Hi,

have a look at string functions and regular expression functions (Perl-compatible).

wizkid

philipolson

It'd be more efficient to use str_replace() as opposed to a regular expression.

examancer

i agree, using a string function for replacing a single character (a space in this case) is much more efficient than using regular expressions. But, both work, so its up to you. The best way to find functions like that is become familiar with how the manual on php.net is organized, and then use the function catagories to find functions you need. If you find a function close to what you need, you will usually find a link in that function to the exact one you need.

ozzythaman

while (!(strstr($words, " ")===false))
$words=str_replace(" ", "", $words);

michael

Originally posted by ozzythaman
while (!(strstr($words, " ")===false))
$words=str_replace(" ", "", $words);

That would be overkill since str_replace replaces all instances.

philipolson

See also your databases string functions, MySQL's can be read about here:

http://www.mysql.com/doc/en/String_functions.html

Specifically, the REPLACE function.