Filenames with spaces in images folder

[vinpkl]

Hi

what to write in select query “where clause” to find the filenames which have spaces in them ??

file 1
file-2
file 3
file-4

so that the result should be

file 1
file 3

thanks
vineet

EDIT : i want to retreive images filename from images folder containing spaces in them. It will be done in php but how ??

[r937]

WHERE filename LIKE '% %'

[vinpkl]

Hi r937

sorry it was my mistake to post it into database category.

actually i want to retreive the filenames from images folder containing spaces in them.

so i think it will be done in php ?? but how ??

Can the administrator please move this question to PHP category ??

thanks
vineet

[cpradio]

You will need to loop over them and look for the existence of a space in the name.

You might be able to use glob with * * too, but I’m not 100% sure about that.