MySQL SELECT LIKE or REGEXP to match multiple words in one record
The field `table`.`name` contains 'Stylus Photo 2100' and with the following query

    SELECT `name` FROM `table` WHERE `name` LIKE '%Stylus 2100%'

I get no results. Of course i would if i searched

    SELECT `name` FROM `table` WHERE `name` LIKE '%Photo 2100%'

How can I select the record by searching 'Stylus 2100' ?

Thanks 
MySQL SELECT LIKE or REGEXP to match multiple words in one record
===

The field `table`.`name` contains 'Stylus Photo 2100' and with the following query

    SELECT `name` FROM `table` WHERE `name` LIKE '%Stylus 2100%'

I get no results. Of course i would if i searched

    SELECT `name` FROM `table` WHERE `name` LIKE '%Photo 2100%'

How can I select the record by searching 'Stylus 2100' ?

Thanks 