search part for part of a string in a field

[c_shelswell]

Hi I've been looking about for this but can't seem to find an answer. I have a string that I need to search in the database for eg 'Fruitshop opens 7am' but my database field only says 'Fruitshop'

 

I thought I could just use a search like: select * from table where field like %Fruitshop opens 7am% but that won't seem to find Fruitshop.

 

Any ideas? Cheers

[c_shelswell]

found the solution! All i needed to do was use a fulltext search maybe this will help someone else:

 

select * from table where match (field) against ('Fruitshop opens 7am')

 

cheers