gassaz

I think it would be done with a php script or some programming language. The mean idea is select row by row on the message table and using the string methods of the programming language to separate the dates and then insert into the new table.

For example: Dates Table Id_dates INT Id_message INT start_date DATE end_date DATE

If you can change the DB structure add a table to store the dates of the messages...

Or you can use: INSERT INTO ....... VALUES .... ON DUPLICATE KEY UPDATE ....

Maybe you can use triggers and stored procedures to emulate a data link.... i know a crazy idea

Sorry, i can't folllow you.....

Reading a bit i found an example similar to your request.. INSERT INTO `day` (`id`, `class`) VALUE (SELECT `id`, `class`='S' FROM `trades2` WHERE `type1` = 'b' AND `price`<=`price1`)

Try changing projp.project_phase_order by MAX(projp.project_phase_order)

You shlould check some variable values of the server, variables like key buffer, sort buffer size. If you database type is InnoDb check variables like buffer pool size. Some times you can improve mysql server increasing this variables.

Try this..

Use LIKE... example: If 'something' exist into the table with accent or with out accent, the select will show the records.