select query help needed

this into a working MySQL select statement? Many Thanks, Dan Lamb -- --- Daniel B. Lamb The Breneman Group, LLC "Consulting, Engineering, Innovation" Website: www.TheBrenemanGroup.com E-Mail: [EMAIL PROTECTED] Office: 513-22

select query syntax help

ResourceLinkTable. I know I could do this with sub-selects like this: Select * from ResourceTable where ResourceID not in (select distinct ResourceID from ResourceLinkTable) How can I do this in MySQL 4.0 without using sub-selects? Thanks, Dan Lamb -- MySQL General Mailing List For list archives

Re: MySQL security

We use MySQL to store financial data and have never had a problem. The things you mentioned (transactions/backup/power failure security) should be used with ANY database that stores critical information that cannot be lost. No database is completely bullet proof. Regular backups stored at an of

Query: how can I select only numeric characters from a string?

Hello All, I have a varchar column containing number and words (not in any specific format) that needs to be separated into two columns. Is there a way to select only the numeric characters from a varchar column in MySQL? Thanks, Daniel Lamb ---

Order by - problem with numerics in varchar field

Hello All, I'm having trouble with ordering. I've got data in a varchar field that currently gets ordered like this when I use 'order by myfield asc': aristo 1001 aristo 156 aristo 222 I'd like it to order like this: aristo 156 aristo 222 aristo 1001 How can I do this in MySQL? Is there a w