Hi.
I have a table with about 650 rows. I am trying to search these rows for certain words. The search works fine with only one word and it returns the correct rows but when i try to search it for a string of more then one row id does not find any matches.
example
searching for "keyboard" will return.
--us standard keyboard.
searching for "mouse" will return.
--standard ps2 scroll mouse.
searching for "keyboard mouse" will return.
--nothing
I want it to return
--us standard keyboard.
--standard ps2 scroll mouse.
I am using
WHERE row_name LIKE '%$search%'
Is there any way to tell mysql to split the string into multiple words and then search or do i have to do that manually.
I have a table with about 650 rows. I am trying to search these rows for certain words. The search works fine with only one word and it returns the correct rows but when i try to search it for a string of more then one row id does not find any matches.
example
searching for "keyboard" will return.
--us standard keyboard.
searching for "mouse" will return.
--standard ps2 scroll mouse.
searching for "keyboard mouse" will return.
--nothing
I want it to return
--us standard keyboard.
--standard ps2 scroll mouse.
I am using
WHERE row_name LIKE '%$search%'
Is there any way to tell mysql to split the string into multiple words and then search or do i have to do that manually.