I’m trying to do a fulltext search on a column post with the following type of search term:
WHERE MATCH (post) AGAINST (“#testinghashtag”)
and MySQL doesn’t seem to be playing friendly with the POUND SYMBOL. What’s the workaround for this? Do I need to store # as a different character in the post column itself?
SELECT COUNT(*) as rows
, COUNT(CASE WHEN post LIKE '%testinghashtag%' THEN 'ok' END) AS tags
, COUNT(CASE WHEN post LIKE '%#testinghashtag%' THEN 'ok' END) AS hashtags
FROM daTable
330 ms. Would you consider that to be good performance? But the question is: what will that look like when there are 1,000,000 posts? 5,000,000? The forum is rapidly expanding, so I foresee a potential scalability problem years out.