Hi,
>> - In oracle you have outer joins, where you have to use a (+)
>>to find rows with null values and stuff like that. Any suggestions on
>>how to do this in MySQL?
You must use the Left Join type syntax in the FROM clause of your query.
>> - The function UNION to connect 2 select queries also doesn't
>>seem to work in MySQL. Any workarounds?
I believe, not yet supported in MySQL.
>> - In Oracle there is a very powerful
>>DECODE(expr1,searchstring1,replacestring1,[searchstring2,replacestring2],[
default])
>> but apparently decode means something else in MySQL. Is there
>>a comparable function in MySQL?
Yes: It's the same as the MSSQL70 function.
CASE expr1 WHEN searchstring1 THEN replacestring1 [WHEN searchstring2
THEN replacestring2] [ELSE default] END
Good luck,
Bruce
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
