Tag Archives: Split Function

When will i search a database one example is, if someone applies in " shed foot", it would go back any instance belonging to the word foot considering the word loose. When they search loose feet, and foot loose is the database, may well show up within the search. Exactly where Field like ”%foot%’ and Field Like ‘%loose%’ The exact formatting within your where clause would depend your database, but this provides you with the general concept. You’d have to split your query having a server-side programming dialect, or in possible of SQL Server the easily available Split function, however it will work. I am just using php & MySQL I wouldn’t really be capable of help you rather than in concept, and then. You’d have to look for a PHP split function most likely and then file format your query keeping that in mind for MySQL. Ideally you’d use like a Lucene index for this kind of thing. However as TheGAME1264 suggests you possibly can perform searches similar to this with MySQL. Though this will have to match every word Something like this would work: (Not completely tested) Just put in a query stringed like s=this+is+a+test towards the page … Continue reading →