[RESOLVED] MySQL REPLACE/TRIM/LOWER/UPPER help needed!

[daveFCA]

I have a column in my table containing words with both upper and lower case and spaces between the words eg. My Name is John Smith

How can I echo this to display mynameisjohnsmith ie. remove spaces and change to lower case?

[NogDog]

SELECT LOWER(REPLACE(column_name, ' ', '')) AS lc_no_space . . .

[daveFCA]

Sorry to be so vague but can you please explain the 'AS lc_no_space . . . ' part?

[NogDog]

That is just assigning an alias for the result of all the string manipulation, which you can then reference just like you would a SELECTed column name.