SELECT * FROM (
select replace(FlightId_IaTa,LEFT(FlightId_IaTa,2),'') as aa,FlightId_IaTa,FlightId
from flightplan ) as c
where aa NOT REGEXP '[0-9]+';
转载于:https://www.cnblogs.com/zh1989/p/5920302.html
SELECT * FROM (
select replace(FlightId_IaTa,LEFT(FlightId_IaTa,2),'') as aa,FlightId_IaTa,FlightId
from flightplan ) as c
where aa NOT REGEXP '[0-9]+';
转载于:https://www.cnblogs.com/zh1989/p/5920302.html