my requirement is as below:
lets product name is "aaa bbb ccc".
Now in search coding i have use LIKE statement.
"... where product_name LIKE '%".$keyword."%'"
Now when user insert 'aaa' or 'bbb' or 'ccc' or 'aaa bbb' or 'bbb ccc' search works.
But if user insert 'aaa ccc' then it is not working.
I want such search result where 'aaa ccc' will also comes in result.
Help me to create query !!