sql like condition help

[kkshansid]

select*from employ where name like '%roy%'
result is
adf roy dff
asd roy
roy fgg
suproyto
i want that only roy on spaces on both sides should come as result
as in my example suproyto should not come in result
kindly suggest any modification in query

[code green]

select * from employ where name like '% roy %'

Don't think MySQL ignores whitespace

[dgreenhouse]

code green is correct...

What your query is requesting is:
Return all records from employ where 'space roy space' is found in name...