full text search – mysql match against multiple words – Stack Overflow

Below is an example sql I am stuck with, it will not return a product named “iphone 4s”, It returns 10 other result. Any help would be great thanks

1st sql example

SELECT * FROM products