如何从Android RoomDB中的字符串列表中查询特定字符串

@Entity(tableName = "your_table_name")
public class YourEntity {
    @PrimaryKey
    public int id;
    
    @ColumnInfo(name = "string_list")
    public List<String> stringList;
}

@Dao
public interface YourDao {
    @Query("SELECT * FROM your_table_name WHERE string_list LIKE '%' || :searchString || '%'")
    List<YourEntity> searchByString(String searchString);
}

@Database(entities = {YourEntity.class}, version = 1)
public abstract class YourDatabase extends RoomDatabase {
    public abstract YourDao yourDao();
}

YourDatabase database = Room.databaseBuilder(getApplicationContext(), YourDatabase.class, "your_database_name").build();
List<YourEntity> results = database.yourDao().searchByString("your_search_string");