I'm having a problem sorting records that are used in a left join statement.
Basically what happens is that any record that is not in table1 doesn't get
sorted correctly. It first sorts all the records that have valid 'c2'
records in both table1 and table2, then moves on to all the records that
o
Hi, I have a mysql table I am searching using the FULLTEXT INDEX feature.
However, the legacy database that I am working from had 90 different fields
holding a keyword in each of them. Since the FULLTEXT INDEX only holds 15
different fields, I would much rather have the fields concatenated into o
