Help Request Extracting user titles via myphpadmin

I have the old database, but need to extract the fields "username" and "usertitle" from table: User

Anyone know the query to run to extract the two into one file? Preferably with a "if empty" skip for empty user titles

 

CREATE TABLE userandtitle AS SELECT username, usertitle FROM User WHERE usertitle <> NULL

Should do it.

 

The query I gave you works