I have been using:
Code: Select all
SELECT *
FROM table
WHERE condition = xCode: Select all
"SELECT *
FROM profile
WHERE commonName LIKE '%$search%'
AND species LIKE '%$searchSpecies%'
AND genus LIKE '%$searchGenus%'
AND category LIKE '$searchCatInp%'";Is there a better way of doing that search using SQL's FULLTEXT command?
Regards,
Dunc