Spaces in like query

[tcardoso]

Hi,

this query:

SELECT * FROM `table` WHERE `field` like '%Some Name%'

give me empty result

and this one

SELECT * FROM `table` WHERE `field` like '%Some%Name%'

gives me the "Some Name" Guy Why does spaces aren't working?

Thanks

 

[towerbase]

I suspect that you either have two or more spaces in your SQL query between Some and Name or your data has two or spaces between Some and Name.

It is possible that another type of white space character is there but I suggest this less probable.

Andrew
Hampshire, UK

 

[tcardoso]

lol.... sorry for that, my "newbiece".

damm user, put two spaces under is name and wasn't appearing on search for others

Thanks mate