我想按照第一个数字对这个字符串列表进行排序,最好在一行中使用正则表达式,但欢迎其他建议。我正试着用最快的方法做这件事。这是名单;
[
"10. iTOMA Radio Alarm Clock FM Digital Radio Clock Bedside Alarm Clock Wireless I",
"11. iTOMA Radio Alarm Clock FM Digital Radio Clock Bedside Alarm Clock Wireless J",
"12. iTOMA Radio Alarm Clock FM Digit
模式:
radio_bin.id
radio.id
radio.radio_bin -> radio_bin.id
查询:
select *
from radio_bin
72排
select *
from radio_bin
where id in (select radio_bin from radio)
50排。
( FWIW:)
select distinct radio_bin
from radio
51行,包括null。
一切都很好。现在:
select *
from radio_bin
where id not in (sel