Does it make any difference for MySQL FULLTEXT indexing in these both case and does the Index take 'words' separated by comma as Words for the Index?
option 1. ",11111,22222,33333,44444,55555," (words separated by comma)
option 2. "11111 22222 33333 44444 55555" (words separated by space)
both columns are TEXT in MyISAM table, with FULLTEXT index.
The questions is are those Words for the INDEX:
,1111,
,2222,
.....
ot it must be:
1111
2222
.....
Thank you! Best!
testing both with no significant difference in timing the results, but need to be sure.
From the documentation:
So your examples should be parsed the same whether the words are separated by space or comma.