Use of User-Defined Variables in a Search Query 9 PostsPachat 4 years ago3TopicHi,Working with tables of thousands of rows, I use the "Search Query" field which gives results (Name, Firstname) on Free tables. Ok.Now, I'd like to have a Search field on top that would allow to find all the rows with taht name.How do I modifiy the SQL Statement : SELECT Name, Firstname FROM #__customers ORDER BY 1, 2to narrow the search to the input of the search box.Something like SELECT Name, Firstname FROM #__customers WHERE Name LIKE '%#sr_name#%' ORDER BY 1, 2 sr_name being the name of the search field.(but that does not work).I need to show all on landing, and then only the searched names. 9 PostsPachat 4 years ago2Level 1I found that this works SELECT Name, Firstname FROM #__customers WHERE [MATCH]Name||$uri->getValue('sr_name')[/MATCH] ORDER BY 1, 2This is inspired from Examples 2 & 3 of http://www.seblod.com/resources/tutorials/using-the-search-query-field-pluginIs there somewhere a documentation that, beyond examples, gives an insight of the use of variables inside Search Queries?For instance [MATCH] generates a " LIKE '%blabla%' " (the fields that contain blabla)How can I generate a " LIKE 'blabla%' "? (the fields that begin with blabla) 154 PostsWebOne 4 years ago1Level 2Maybe you are looking for something like this ?http://www.pulsar-informatique.com/telechargements-gratuits/autocomplete-field-plugin 9 PostsPachat 4 years ago0Level 3Yes. Thank you for the link.