what is the easiest way on a wordpress site to have a database of unique ID numbers and have a search field that searches the exact phrase and displays results?
mySQL database search exact phrase
Leave a Reply
You must be logged in to post a comment.
create a table to have unique ids, and words
To search by a word
then use ->
SELECT * FROM words_table WHERE word LIKE "%ed%";This will return results where ed is in words such as end*ed*, start*ed*, startl*ed*, *ed*ucation
To search by an id
use ->
SELECT * FROM words_table WHERE id = {$id}