Is this MySQLi or standard MySQL? It would be done in the PHP not just the SQL statement. I'd probably just do:
SELECT * FROM client_help WHERE Live = 1 OR 1 = ? ORDER BY HelpOrder ASC
Then use a parameter that you set to 0 for non admin and set to 1 for admin so that admin would end up with:
SELECT * FROM client_help WHERE Live = 1 OR 1 = 1 ORDER BY HelpOrder ASC
and non admin will have:
SELECT * FROM client_help WHERE Live = 1 OR 1 = 0 ORDER BY HelpOrder ASC