Re: partial match of field in table for SELECT statement

[Sebastiano Battaglia]

Peter,
thanks for the reply.

I did design it myself, you can def say rookie since I never worked with databases :)

the "-" I know have to be escaped with a tick and that's fine.

I honestly don't know what the MyISAM engine is, I'm using the system that IT gave me.

for the design that you have, i need to put it in a loop since I gotta create 45 different tables, each corresponding to a txt file that I have.

how would that be then, performance-wise, when I have to retrieve the data? would that be faster than my previous version?

I'm retrieving data through RMySQL in R (a statistical software), but it does take some time to extract and compile all the data

thanks

Seb