Re: MS SQL to MySQL select

2008-06-16 Thread SenTnel
Thanks Martijn! That I understood, sorry I wasn't clear enough, I was more confused about the TOP 100 PERCENT and this was a bad example anyways, but after posting I did some deeper research and found an excellent migration white paper describing this type of expressions and mysql counterparts.

MS SQL to MySQL select

2008-06-14 Thread SenTnel
Hello! In order for me to achive the goal of migrating a MS SQL based application to web based php / mysql I need to understand a little bit MS SQL syntax and MySQL counterpart expression. If is not too much to ask one of you guys could translate this MS SQL select to MySQL? Here's the

Exporting blob / text column with hyphen delimited text

2007-06-01 Thread SenTnel
Hi all! I have a table that contains a column (blob, text type, formatted as MEDIUMTEXT) with text hyphen (-) delimited, listing rooms by numbers, and I need to export or insert that data into another table, where all other info on the other columns remains the same, but I need the data on the