If you are familiar with SQL, you can do that directly as follows:
[abase sql=’select cultivar,hybrid from asa_plants where cultivar in (“Carolyn”,”Bob Stewart”)’]
The above is a query from my database, obviously, but yours should be similar. Note that the text from the search field will need to be enclosed in double quotes, as shown, and the whole query in single quotes.
Note that abase does not work with PHP 7. I have a fix for that if you are interested.
What are plugin are you using to generate the search form?
Thanks Paul. I am using Abase plugin to generate search form. Here is the link to plugin – https://wordpress.org/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.