Thanks Paul. I am using Abase plugin to generate search form. Here is the link to plugin – https://www.ads-software.com/plugins/abase/. But, unfortunately the SQL query you mentioned won’t help me as I want a text box where people will enter search text 1 every line and it would search from my database and display the results.
JUST LIKE THIS –
USNLE
JFHK8
K3JFHR
FHFHE
THE LIST CAN GO ON. IT SHOULD SHOW THE RESULTS ACCORDINGLY. I DON’T WANT THE SQL QUERY BUT SHORTCODE USING ABASE PLUGIN OR ANY OTHER PLUGIN WHICH CAN DO THIS.
