Re: Formatting data in a query

Thanks in advance! You want to use the SUBSTRING function. E.g. SELECT password, SUBSTRING(username, 1, 6) FROM my_table WHERE ... See the MySQL manual for more info: http://www.mysql.com/doc/en/String_functions.html Thanks, Colin Anderso

repeated crashes (buffer overrun?)

We just brought a database back up after bringing it down for a hardware upgrade (added hard drives) and after we brought it back up it started crashing a lot. The queries that crash it vary. I realize it might be simple case of database corruption (the data files are now on a different physical

speed optimization on awkward self join

I'm starting to get pretty comfortable with mysql, but I'm still a beginner, and I've run into a problem I can't seem to get around. I'm having trouble getting a particular query to run within anything approaching a reasonable amount of time -- I'm not sure whether it's a problem with my query s