I have an active website that connected with SQLite database. And on search page, I make it as:
$sql = “select * from table where column1 like “\%$q%”\”;
However, after I try to search with 52 brand ceiling fan
. A result gives empty. But if search with brand 52 ceiling fan
. There has a result to show.
I know Full Text Search is performance way to solve this issue. But with my active website and database. Is there anyway to working without creating new database?
Thank