Hello everyone - first time poster here, long time reader.
I have a minor issue that appear to simple to fix - but I’ve just hit a road block. I would like to create a three way inner join to display all the information I need in one SQL statement.
Let me describe the issue. I have [...]

• 0 Comments

Hi all,
In a table column, I have this address value:
"Muehlgasse 1 86637 Wertingen GERMANY"
I want to get only the GERMANY part on my SELECT code. I’ve tested this code:
SELECT right(’Muehlgasse 1 86637 Wertingen GERMANY’,7)

It works, but the ‘7′ has to be calculated, because we have other countries, too.
Any idea?? Thanks

• 0 Comments

I have a query
SELECT radcheck.id, radcheck.UserName, radcheck.epost, radcheck.fylke, MAX( radacct.AcctStopTime ) AS AcctStopTime
FROM radcheck
LEFT JOIN radacct ON radcheck.UserName LIKE radacct.UserName
WHERE AcctStopTime LIKE ‘%2009-03-19%’
GROUP BY radcheck.id

I’m looking for a way to use wilcards, > <, NOT LIKE etc on only the highest date value AcctStopTime in the radacct table. The above query without the WHERE
clause [...]

• 0 Comments

Hi,
I have mysql database dump xxx.sql
How can i convert xxx.sql to xxx.csv?
Thanks

• 0 Comments